This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality. This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.
Continue reading “Dynamics GP & Power BI – Publish using a custom SQL View”
This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality. This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.
How to see registered Apps on your Power BI account
Continue reading “Dynamics GP & Power BI – How to see Apps registered to your account”
This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality. This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.
How to connect Power BI to GP Home Screen
Dynamics GP can display reports that are pinned to a dashboard in Power BI. After following these instructions, if you do not see any available reports, be sure to add them to a Dashboard in Power BI. I created a Dashboard called GP PBI (in Power BI) and only pinned the reports that I wanted to optionally display in Dynamics GP.
Continue reading “Dynamics GP & Power BI – Power BI on your GP Home Screen”
This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality. This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.
Continue reading “Dynamics GP & Power BI – Connecting GP OData to Power BI Desktop”
This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality. This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.
How to Configure the OData Service in Dynamics GP
Continue reading “Dynamics GP & Power BI – Configure OData Service in Dynamics GP”
This blog post is part of a series of blogs designed to help a business understand the interaction between Dynamics GP and Power BI, how to setup Power BI with Dynamics GP and what some of the options are for this functionality. This write up was done using Dynamics GP 2018.
To view the full list of the series, click here.
How to Setup the OData Service with Dynamics GP
Continue reading “Dynamics GP & Power BI – Setting up the OData Service”
Dynamics GP has had a few iterations of its Power BI integration over the years. I was very excited to see Power BI functionality in GP – this started with ~Dynamics GP 2016. Despite my excitement, I found it hard to ‘get on board’ as the functionality was limited and somewhat unreliable. Microsoft heard our case and delivered many changes with Dynamics GP 2018. The Power BI and Dynamics GP friendship has been renewed and I think you will really like it!
I have implemented this for a few businesses who use Dynamics GP… they LOVE IT, and so do I! This blog is meant to outline how this functionality works in GP and in Power BI. There is a lot to cover… and to keep our “millennial” attention spans primed, I broke this into a few blog posts.
Some of this is already available from other sources, but for my own reference, I wanted to create a series so I can easily reference it all in one place… as I learn more, I will update these blogs accordingly.
Continue reading “Dynamics GP & Power BI – What it does and how to use it – New for GP2018”
