Informations :

Microsoft Dynamics GP 2016 - Power BI Feature

In GP 2016 you can now add Power BI visuals to the Home page. 
Download the documentation HERE!
I'm not going to rehash the documentation here, so make sure to read through it prior to reading through the rest of this blog.  I do want to add some additional information that may help you get started.  You can navigate to the following site to sign up for a free trial of Power BI.  https://powerbi.microsoft.com/en-us/
With a Free Trial of Power BI you can get GP connected and test out this new feature.  The instructions ask you to Register a client App with the Power BI App Registration Tool.  This will direct you to go to https://dev.powerbi.com/apps.  This is how you get a 'Client ID' which needs to be entered into the Reporting Tools Setup window.  Once you've signed into this site it is going to ask you for the following information.
App Name - You can name this anything you want.
App Type - Specify this as 'Native App'
Redirect URL - example: https://login.live.com/oauth20_desktop.srf
APIs to Access - I believe the minimum you need here is 'Read All Dashboards'.  I always check all the boxes when I set it up though.
Once you've provided the above information you should be able to click on the 'Register App' button and get your client ID.  This is what you will put into the Reporting Tools Setup window for Power BI.  You should record this ID somewhere else in case you need it again.  You will have to setup a new one if you lose it.
The other issue I'd like to talk about is the possibility of running into a Script error when loading the Power BI reports on the GP home page.  You will get something along the lines of:
An error has occurred in the script on this page.
Error: Invalid Character
URL: https://app.powerbi.com/13.0.1100.519/scripts/powerbivisualrenderer.min.js
When we request the Power BI visual from the Power BI site it has to run through the above referenced renderer.  This renderer delivers a picture of the report to us that can be loaded onto the GP Home page.  This renderer does not support every kind of report\visual that you could potentially load up to the Power BI site.  Full page reports, full fidelity excel tiles and models will not work.  If you pin an individual tile from a report it should work.

No comments