The MS Connect site, which was the one-stop repository for ideas/suggestions/bug fixes relating to Dynamics GP (among other things) was retired not too long ago.
Since then, I have had many discussions, online and in person, regarding its replacement. And so far, the replacement was ‘in the works’… until now.
Continue reading “Looking for the MS Connect replacement for Dynamics GP?”
Tag: 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 resolve “This login failed. Attempt to login again or contact your system administrator” error when connecting to Client ID
Continue reading “Dynamics GP & Power BI – Resolve Error: This login failed”
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 delete APP registrations
Continue reading “Dynamics GP & Power BI – How to delete APP registrations”
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 publish a custom SQL View to Power BI
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
Step 1: Visit portal.azure.com
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.
Step 1: Obtain Client ID
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.
How to connect Dynamics GP OData to Power BI
Step 1: Install Power BI Desktop (you will need an account as well).
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
Step 1: Navigate to Reporting Tools Setup
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”