Power BI Report in Dynamics 365
In Dynamics 365, We can develop Power BI reports using the "ODATA" entity model. In doing so, we can see "cross-company" data in which we can apply the filters at run time without any refresh or loading time. Steps to develop power BI Report includes the following Visual Studio Steps: 1. Make the Query from which data needs to be pulled. 2. Assign that query to AX View . 3. Create a Data Entity and assign the view in the data source of entity. 4. Create a unique Index in the entity 5. Generate the Staging Table by right clicking on data entity then click on generate staging table. 6. Create the Security Privileges for entity. 7. Build the project. Figure 1: Visual Studio Objects Power BI Desktop Steps: 1. Open Power BI Desktop. 2. Select the "Get Data" from power BI Desktop 3. Select "More..." as shown in figure 2 Figure 2: Power BI Get Data Tab 4. In the "Online Services" , select "Dynamics...