Dynamics 365 FO: Configure PowerBI on Developer VM

[@sritoxic]

This is the step by step way to configure Dynamics with PowerBI and the best one i found yet.

[@SYG4M3R]

Can you help, when I changed the data source and applied query changes at 14:18 the report displays no data (blank). Do you have any idea what the issue might be?

[@ERPCoder]

This can be an issue with the datasource. Does the automatic refresh work?

[@SYG4M3R]

@@ERPCoder No. I think what's happening is that AxDW is empty and has no data. I assumed there should be demo data inside it, is that not the case?

[@ERPCoder]

@@SYG4M3R You have to start the population of by hand, go to Administration > Setup > Entity Store . There you can start the refresh manually and setup a periodic refresh e.g. once a day or every hour . This may take a while

[@SYG4M3R]

@@ERPCoder Ok I'll try that. Thank you very much for helping 👍

[@SYG4M3R]

@@ERPCoder I just tried your suggestion and now everything works fine! Thanks again for your help.

[@alexyakovlev2817]

Thank you, Markus! Could you advise - how many Power BI Pro licensies is needed if (for example) 20 Dynamics users want to view PowerBI report?

[@fernandovillaman3580]

Hi Markus, thanks for the excellent Walktrough. The only thing that I dont fully understand its how you set the automatic refresh for the data for the reports. Any help would be appreciated. Thanks!

[@ERPCoder]

The embedded PowerBI reports use direct query on the AxDW, not import mode. Refresh is done by the jobs in D365 that populate the AxDW database.

[@fernandovillaman3580]

@@ERPCoder Thanks! I tried this via Entity Store and works great

[@codetest1730]

I've followed the steps, however when I open the templates on power bi desktop I get an error that "the keys didn't match any rows in the table"

[@rubenknudsen3939]

Thank you, great walkthrough

[@sksingh763]

Wonderful!!!!!