Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
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!
Hi Jeff, How do you publish the associated date range widget into the Dashboard?
Business Applications communities