BenchMark Quizzes by MDFT Pro

Replace Excel Workbook Data Source In Power BI

You create a Power BI report at MDFT Academy using an Excel workbook stored on OneDrive for Business as the data source. The academy regularly updates the workbook with new data and wants the report to keep working without rebuilding visuals or queries.

You need to replace the workbook with a new version containing updated data, without editing the report. What should you consider to ensure the report remains functional?

Choose all correct answers from the options below.

Explanations for each answer:

The Excel workbook must be overwritten in the same OneDrive location with the same file name. is correct. Overwriting the file at the same path ensures the report continues to refresh without updating the data source connection.
The Excel workbook must have the same structure as the original workbook. is correct. The workbook’s structure (tables/sheets and columns) must match the original, or Power BI queries will fail.
The Excel workbook can be edited in Power BI. is incorrect. You cannot edit the workbook in Power BI; you must edit it in OneDrive for Business or Excel.
You can move or rename the Excel workbook in OneDrive without having to update the data source connection in Power BI. is incorrect. Moving or renaming the file changes its URL; you must update the data source settings for the report to refresh successfully.

Learn more about importing Excel workbooks in Power BI:

Import Excel Workbooks

Exam Preparation Quiz

Replace Excel Workbook Data Source In Power BI