If you are not familiar with Project “Madeira” or would like to learn more about the Preview, please take a few minutes to read my post titled: Project “Madeira” Preview has arrived & here’s everything you need to know!
Update (April 18, 2016): When this article was initially published on April 14, we were unable to connect Project “Madeira” to PowerBI.com. This issue has been resolved, and the article has been updated to reflect this. A big thank you to Theresa from the Microsoft team that developed the Content Pack for reaching out to me!
Are you wondering if Power BI will work with Project “Madeira” like it does with Dynamics NAV?
Just head over to PowerBI.com and you will find that there’s already a Project “Madeira” content pack ready to use!
In minutes, you can have a dashboard full of KPIs and dozens of reports ready to use.
Connecting Project “Madeira” to PowerBI.com (updated)
Complete connection instructions can be found on the official Project “Madeira” site: Using the Project “Madeira” Content Pack for Power BI
Like Dynamics NAV 2016, all the Web Services necessary for Power BI are configured and ready to go in Project “Madeira”.
The OData Feed URL also follows the same format: https://[navserver]/[instance]/OData/Company(‘Company%20Name’)
If you’re not sure about the URL for your tenant, you can find it listed on the Web Services page in the OData column in Project “Madeira”.
Unlike Dynamics NAV 2016, where the NavUserPassword authentication method is required for the backend, Project “Madeira” uses the combination of “User Name” and the user’s “Web Service Access Key”.
In my tenant, my user did not have a Web Service Access Key, but I was able to generate one from the User card page by clicking on “Change Web Service Key” on the ribbon.
In PowerBI.com, go to Get Data > Services, click on the Project “Madeira” content pack, and click on the ‘Connect’ button.
Enter the OData feed URL as explained above, and click on ‘Next’. Select ‘Basic’ as the Authentication method, and enter the User name as shown in the screenshots, and the Web Service Access Key as the password.
Finally, click on ‘Sign In’ and PowerBI.com will have your dashboard and reports ready for use in no time at all!
To learn more about Microsoft Power BI, or how to connect an instance of Dynamics NAV to PowerBI.com, check out our blog post titled: Microsoft Power BI for NAV: Simple. Powerful. FREE