Hello All,

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!