How to Connect Power BI to Dynamics 365 Entity Store for Seamless Report Migration?
Table of Contents
Question
You are creating a new report using Power BI Desktop to analyze the company’s financial data.
You need to connect Power BI Desktop to the local Entity Store database in your development environment and create a report that can be migrated to the production environment.
What three steps should you perform? Each correct answer presents part of the solution. Choose three.
Select all answers that apply.
A. Start Power BI Desktop, select Get Data > SQL Server, enter ‘.’ as the server name and ‘AxDW’ as the database name, and select the DirectQuery option.
B. Select the RetailCube aggregate measurement in the Entity Store page and select Refresh.
C. Use the Import option in the SQL Server Database dialog box.
D. In the SQL Server Database dialog box, select OK, then in the Navigator dialog box, select the RetailCube_RetailTransDetailsView table and select Load.
E. Create the report by dragging measures and fields to the canvas, and explore data and trends interactively.
F. Publish the report to PowerBI.com and pin it to the client.
Answer
A. Start Power BI Desktop, select Get Data > SQL Server, enter ‘.’ as the server name and ‘AxDW’ as the database name, and select the DirectQuery option.
D. In the SQL Server Database dialog box, select OK, then in the Navigator dialog box, select the RetailCube_RetailTransDetailsView table and select Load.
E. Create the report by dragging measures and fields to the canvas, and explore data and trends interactively.
Explanation
The correct steps to connect Power BI Desktop to the local Entity Store database and create a report are to start Power BI Desktop, select Get Data > SQL Server, enter ‘.’ as the server name and ‘AxDW’ as the database name, and select the DirectQuery option, then select OK in the SQL Server Database dialog box, select the RetailCube_RetailTransDetailsView table in the Navigator dialog box and select Load, and finally create the report by dragging measures and fields to the canvas, and explore data and trends interactively. The Import option in the SQL Server Database dialog box is not currently supported. Selecting the RetailCube aggregate measurement in the Entity Store page and selecting Refresh is not necessary for this task. Publishing the report to PowerBI.com and pinning it to the client is a step for integrating the report into a demo environment, not for creating a report in the development environment.
Microsoft Dynamics 365: Finance and Operations Apps Developer MB-500 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Dynamics 365: Finance and Operations Apps Developer MB-500 exam and earn Microsoft Dynamics 365: Finance and Operations Apps Developer MB-500 certification.