Microsoft Power BI Data Analyst — Question 33

You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network.

You are notified that the Excel data source was moved to a new location.

You need to update the PBIX file to use the new location.

What are three ways to achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Answer options

• A. From the Datasets settings of the Power BI service, configure the data source credentials.
• B. From the Data source settings in Power BI Desktop, configure the file path.
• C. From Current File in Power BI Desktop, configure the Data Load settings.
• D. From Power Query Editor, use the formula bar to configure the file path for the applied step.
• E. From Advanced Editor in Power Query Editor, configure the file path in the M code.

Correct answer: B, D, E

Explanation

Option B is correct because it directly allows the user to update the file path in the Data source settings of Power BI Desktop. Options D and E are also correct as they provide methods to change the file path using the Power Query Editor, either via the formula bar or by modifying the M code in the Advanced Editor. Options A and C do not address changing the file path directly, making them incorrect solutions for this scenario.