Microsoft Power BI Data Analyst — Question 121

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?

Answer options

• A. Power BI dataset
• B. a SharePoint folder
• C. Power BI dataflows
• D. an Excel workbook

Correct answer: A

Explanation

The correct answer is A, Power BI dataset, as it allows you to leverage the existing data model and measures without needing to rebuild them. The other options, such as a SharePoint folder, Power BI dataflows, and an Excel workbook, would require additional development effort to recreate the measures or data connections.