PL-300 · Question #377
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 t
The correct answer is B. From the Data source settings in Power BI Desktop, configure the file path. 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.. Updating the file path for a Power BI data source can be achieved directly through the Data source settings in Desktop or by editing the M code in Power Query Editor.
Question
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.
Options
- AFrom the Datasets settings of the Power BI service, configure the data source credentials.
- BFrom the Data source settings in Power BI Desktop, configure the file path.
- CFrom Current File in Power BI Desktop, configure the Data Load settings.
- DFrom Power Query Editor, use the formula bar to configure the file path for the applied step.
- EFrom Advanced Editor in Power Query Editor, configure the file path in the M code.
How the community answered
(57 responses)- A16% (9)
- B75% (43)
- C9% (5)
Why each option
Updating the file path for a Power BI data source can be achieved directly through the Data source settings in Desktop or by editing the M code in Power Query Editor.
Dataset settings in the Power BI service primarily manage credentials for published datasets via gateways but do not allow direct modification of source file paths for an Excel file that has moved.
Power BI Desktop's Data source settings provide a centralized interface to modify the connection details, including file paths, for all data sources in the PBIX file.
Data Load settings under Current File in Power BI Desktop control data loading behavior (like parallel loading or time intelligence options) but do not include options for changing source file paths.
In Power Query Editor, for the step that defines the data source (e.g., File.Contents), the file path can be directly edited in the formula bar for that specific applied step.
The Advanced Editor in Power Query Editor allows direct manipulation of the M code, where the file path string for the data source connection can be located and updated.
Concept tested: Updating Power Query data source connections
Source: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-edit-data-source-settings
Community Discussion
No community discussion yet for this question.