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.
From the Data source settings in Power BI Desktop, you can directly configure the file path, allowing you to update the connection information for the Excel data source. In Power Query Editor, using the formula bar, you can modify the file path for the applied step if it showcases the source step. Additionally, the Advanced Editor in Power Query Editor permits editing the M code, which includes updating the file path to the new location of the Excel data source. These methods ensure the PBIX file correctly references the new file path.
The answer is correct! B, D and E are the correct options!
B. From the Data source settings in Power BI Desktop, configure the file path. This option allows you to update the connection information for the Excel data source, including changing the file path to the new location. D. From Power Query Editor, use the formula bar to configure the file path for the applied step. If the source step in Power Query shows the file path, you can change it directly in the formula bar to reflect the new file location. E. From Advanced Editor in Power Query Editor, configure the file path in the M code. The Advanced Editor lets you edit the M code directly, which includes updating the file path to the new location of the Excel data source.
B,C,E IS CORRECT
c IS NOT CORRECT
C is INCORRECT!
corrrect
Correct answer
Checked: Correct
Correct
Not sure about A though
Actually I did a quick research and apparently YOU CAN EDIT THE CREDENTIALS FROM SERVICE but YOU CANNOT EDIT THE INPUT PATH FROM SERVICE... Meaning you can only do it from Desktop. So BDE are correct.
Correct anwser BDE
c is correct as well IMO. Data Source settings has the "change source option".
options C is not about changing it through 'transform data' and then 'data source settings'. (where the path can be changed indeed). In the answer is mentioned the 'data load' which is under 'current file' when you go to 'option and settings' from file menu. And there you don't have the possibility to change the path