I created a template that you can download into your Power BI Desktop instance, connect to your Dynamics GP data with a SQL ODBC connection, to create a basic dashboard.
To start you will want to open Power BI Desktop and Import the Template:
File >> Import >> Power BI Template
Next you will need to change the source of the queries to be your SQL server and GP Company Database:
Edit Queries >> Data Source Settings
I’ve done this part only a limited number of times, but it should work. Email me if you have problems.
Oh, yeah. Here’s the template: dynamics-gp-dashboard-5
This will create a Report that looks like this in Power BI. This example is interactive (Embed):
You can then smash these onto a Dashboard that looks something like this:
