With the release of Dynamics GP 2016, many features have been introduced among which Power BI integration with Dynamics GP, this may be one of the most important features along with the HTML5 and OData Services.
In this post, I am going to shed a light on how to configure the Power BI in details.
Power BI Integration Prerequisites:
- Office 365 Account which entitles you to access Power BI
- At least one Power BI site including at least a report / dashboard
- Dynamics GP 2016 desktop client is installed
Power BI Configuration:
- Go to Microsoft Dynamics GP > Tools > Setup > System > Reporting Tools Setup.
- There is a new tab for "Power BI" configuration
Reporting Tools Setup |
As for the power BI site, login to the Power BI using your office 365 credentials, the Power BI Site URL is highlighted below:
Power BI Site URL |
In order to obtain a client ID, follow the steps below:
- Go to Power BI for Developers >> Link
- Log in to your Power BI Account
- Fill in the following details
- App Name: Dynamics GP
- App Type: Native App
- Redirect URL: https://login.live.com/oauth20_desktop.srf
- Choose APIs to access, which are categorized as follows
- Data set APIs
- Report and Dashboard APIs
- Other APIs
- Click on "Register your App", and the client ID will appear in the box below
Power BI for Developers - Client ID |
Power BI for Developers - Client ID |
Now you can get back to Dynamics GP, and fill in both the Power BI Site and Client ID, and click "OK" to proceed. Now on Dynamics GP Home Page, click on "Customize" and make sure to check the Power BI component as shown below:
Customize Home Page |
Please note that there is an option to "Show All" power BI selected reports on the home page. If it not checked, then all reports will appear within the same part with an arrows to go through them one by one.
To proceed, click on the "pencil" icon in order to change the details of the Power BI Component, through which you can check/ select which reports to show on Dynamics GP Home Page. It might prompt a login window requesting office 365 credentials in order to access the Power BI site and retrieve the reports and dashboard details:
Customize |
Power BI Details |
Finally, Dynamics GP Home Page and Power BI reports/ dashboard is presented based on the choices/ selections made above.
Best Regards,
Mahmoud M. AlSaadi
Fantastic stuff, thanks Mahmood.
ReplyDeleteConfiguration worked first time following exactly what you referenced. However, I have had trouble displaying the data - simply get an 'oops, couldn't find the page' error.
Any thoughts comments on connectivity issues?
Thanks
Marius
Hello there,
DeleteIt is usually due to connectivity, I've had the same issue when the connection encountered a glitch, a penguin icon was shown with an error :)
Just make sure that the connection is working properly.
Best Regards,
Mahmood,
ReplyDeleteLove the information. I have a question about Registering the App. I'm unable to select any API choices in Step 3 "Choose APIs to access"
Any thoughts?
Would you please elaborate more, in fact I never had a single issue selecting the API.
DeleteBest Regards,
Mahmoud M. AlSaadi
I was able to enter in the information in the reporting tools setup window. It asked me to log in and it seemed to work. I was able to add Power BI to my home page. When I click on the pencil it does not show any report. Says unable able connect to power BI site. contact your admin
ReplyDeleteHi Mahmoud,
ReplyDeleteThe 2016R2 Power BI setup screen has changed since RTM and doesn't show the same field anymore.. the URL is missing. Did you tested your setup with the R2 release ?
This helps the readers a lot Power BI Online Training Hyderabad
ReplyDeleteMake sure you choose the GP Admin option...oData. From this option in GP Administration select the SQL tables for data connecting. Should solve connectivity issue assuming other steps performed properly.
ReplyDeleteHello Mahmoud,
ReplyDeleteI trust that you are well.
I am checking out this post only now.
i am trying to do this with GP2018.
I have all the setups completed etc.
The only issue I have is when I add the reports / dashboards from Power BI onto the GP Homepage, the graphs and data is too small.
Do you know what I may need to do in order to make mine look like you have in your example?
Regards,
Jay
Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog onpower bi online course
ReplyDeleteThanks for details explanation here.
ReplyDeleteMicrosoft Power BI Online Training
When it comes to digital matchmaking and networking many virtual events still struggle and leading platforms are still experimenting with innovative ways to bring people together at hybrid events. event marketing and Top 5 Best Virtual Event Software Platforms of 2021
ReplyDeleteHello everyone I want to introduce you guys to a group a private investigators who can help you with information you need in any situation in life and they are ready to follow you step by step until your case is cleared just contact +17078685071 and you will happily ever after
ReplyDeletePremiumhackservices@gmail.com
sql azure online training
ReplyDeletehyperion online training
Remarkable! the way you produce your content I like it!
ReplyDeleteBest International School in Ghaziabad
This is Great Article. You are post informatics blog so keep posting.
ReplyDeleteWebsite Designing Company in Noida
ERP Software in Delhi NCR
Top 10 CBSC Schools in Meerut
Delhi Bazar Satta King
Top Digital Marketing in Meerut
satta Result Chart
Latest and Breaking News in Hindi
BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast
ReplyDeleteyou can be to get the new PROGRAMMED blank ATM card that is capable of
hacking into any ATM machine,anywhere in the world. I got to know about
this BLANK ATM CARD when I was searching for job online about a month
ago..It has really changed my life for good and now I can say I'm rich and
I can never be poor again. The least money I get in a day with it is about
$50,000.(fifty thousand USD) Every now and then I keeping pumping money
into my account. Though is illegal,there is no risk of being caught
,because it has been programmed in such a way that it is not traceable,it
also has a technique that makes it impossible for the CCTVs to detect
you..For details on how to get yours today, email the hackers on : (
atmmachinehackers1@gmail.com ). Tell your
loved once too, and start to live large. That's the simple testimony of how
my life changed for good...Love you all ...the email address again is ;
atmmachinehackers1@gmail.com
Thank you for providing such a thorough explanation.
ReplyDeletefullstacktrainingcenter
The integration of Power BI with Dynamics GP 2016 enhances reporting capabilities, enabling real-time data visualization directly on the GP dashboard. This seamless process strengthens decision-making and boosts productivity with custom report selection.
ReplyDeletefullstacktrainingcenter