Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsMedium
A data analyst is refactoring a complex Power BI report. The report contains a dataset with multiple tables and measures. To improve performance and maintainability, the analyst wants to isolate the dataset into a separate Power BI file and allow multiple reports to connect to it. What is the most effective way to achieve this in Power BI?
- ACopy and paste the dataset tables into a new Power BI Desktop file.
- BExport the data from the current report and re-import it into new reports.
- CUse 'Analyze in Excel' feature and connect reports to the Excel file.
- DPublish the dataset as a shared dataset to the Power BI service.
Show answer & explanationAnswer & explanation
Correct answer: D. Publish the dataset as a shared dataset to the Power BI service.
Publishing a dataset as a shared dataset to the Power BI service allows it to be reused by multiple reports. This promotes a 'single source of truth' for data, improves consistency, and simplifies maintenance, as updates to the shared dataset benefit all connected reports.
Why the other options are wrong
- A. Copying tables would create duplicate datasets, defeating the purpose of a shared source and increasing maintenance overhead.
- B. Exporting and re-importing data creates disconnected data silos and is highly inefficient for this scenario.
- C. 'Analyze in Excel' allows connecting to a dataset, but the Excel file itself is not the shared dataset for other Power BI reports.
Shared Power BI Dataset
A shared Power BI dataset is a dataset published to the Power BI service that can be reused by multiple reports, promoting data consistency and simplifying maintenance.
- Single source of truth
- Reusable by multiple reports
- Reduces data duplication
- Simplifies data model maintenance
Memory trick: Share the dataset, share the truth, share the work.