PL-300 · Question #468
You use Power BI Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share. File1 is moved to a different folder. When you open
The correct answer is A. Change the data source.. When an Excel file is moved to a different folder, Power BI Desktop retains the original file path as the data source connection string. Refreshing the report fails or returns stale cached data because the file no longer exists at the stored path. The correct fix is to change the
Question
You use Power BI Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share. File1 is moved to a different folder. When you open RPT1 in Power BI Desktop, you discover that the report displays outdated data. You need to ensure that the data in File1 refreshes properly. What should you do?
Options
- AChange the data source.
- BClear the permissions of File1.
- CExport a PBIDS file.
- DModify the permissions
How the community answered
(54 responses)- A81% (44)
- B6% (3)
- C9% (5)
- D4% (2)
Explanation
When an Excel file is moved to a different folder, Power BI Desktop retains the original file path as the data source connection string. Refreshing the report fails or returns stale cached data because the file no longer exists at the stored path. The correct fix is to change the data source settings in Power BI Desktop (Home > Transform data > Data source settings) to point to the new file location. Permissions (Options B, D) are unrelated to a moved file. Exporting a PBIDS file (Option C) creates a shareable connection file but does not update the source path within the existing report.
Community Discussion
No community discussion yet for this question.