Continuing with our Power BI blog series, today we will create a Sales report using Dynamics GP data published via the OData service!
The following video provides a step-by-step walkthrough for creating the report in the Power BI Desktop application:
As noted, this assumes that you have already installed and configured the OData service to publish the Dynamics GP data feeds. If not, please refer to the following article:
Here is the article mentioned regarding drill-through not being supported when using Calculated Measures:
Here is the article mentioned regarding the workaround for the known issue with the "Show Items with no data" option not working when using a Slicer:
If you would like to download a template of the Sales report and immediately begin using it in Power BI, it is available here:
Dynamics GP Sales Report.zip
If you haven't already done so, I would also recommend trying the GP 2018 Power BI Content Pack available via the following article:
When you are ready to display your Power BI reports on the Dynamics GP Home Page, you can refer to the steps in the following article:
See the following article for more tips and tricks with Power BI report design for Dynamics GP:
Feel free to leave any questions or comments below. Thanks for watching!