Question
For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.
The data model contains several measures.
You need to create a Power BI report from the existing data. The solution must minimize development effort.
Which type of data source should you use?
- A. Power BI dataset Correct
- B. a SharePoint folder
- C. Power BI dataflows
- D. an Excel workbook
Explanation
The published report already has a dataset (semantic model) containing the data and the measures. Connecting a new report to that Power BI dataset reuses everything without rebuilding anything. Connecting again to the SharePoint folder or the Excel workbook would require recreating the transformations and measures, and no dataflow exists for this data.
