How to Integrate Power BI with Project Madeira

By Warren Young | June 3, 2016

How to integrate power bi with project madeira

*This post was written for Dynamics NAV but the content directly applies to Dynamics 365 for Financials, which is the cloud product based on Dynamics NAV. You may notice some slight differences in the screenshots, but the information and steps are directly applicable to Dynamics 365 for Financials.

*Update: With the release of Dynamics 365 for Financials (formerly called Project Madeira) this post has been updated. Please find How to Integrate Power BI with Dynamics 365 for Financials here.

This post will cover how to integrate your Project Madeira instance directly with Power BI (free version).
Project Madeira is based on Dynamics NAV, so this walkthrough will be similar to our Power BI with Dynamics NAV – Demo Install blog post.  The largest difference with Project Madeira deployments built into Office 365, there is no on-premise option and gateway to consider.  We’ll walk through the necessary Office 365 data authentication to get www.powerbi.com to connect to your Project Madeira instance.
Power BI

Prerequisites

  • O365 Account with Project Madeira and Power BI (free) accessible – this is normally not an issue unless you are in a O365 demo/tenant environment with limited appsContents
  • Verify User Account and Web Service Authentication Key
  • Verify OData for the Dynamics NAV Service Tier
  • Power BI Get Data – Connect to Project Madeira

Verify User Account and Web Service Authentication Key

1. In Project Madeira, navigate to the “Users” page.  (Either use the Search for “Users” or navigate to Company Settings > Users)
2. Select your User Account and click Edit
Project Madeira in Power BI
3. Verify your User Name (which may be different from your O365 account)
4. Verify your “Web Service Access Key” if the field is blank or you’d like to generate a new one, click “Change Web Service Access Key” in the ribbon.
 Project Madeira in Power BI
We’ll be using the User Name and Web Service Access Key in upcoming steps.

Verify the Office 365 Data URL is Accessible

1. You can find the Office 365 Data URL within Project Madeira:
a. Use the Search to find Web Services
b. Copy the OData URL from one of the services and strip off the end, up to the Company() portion.
 Query in Power BI
Syntax:  http://:/MS/OData/Company(‘’)
Example:  http://mydemo.projectmadeira.com:7048/MS/OData/Company(‘CRONUS US’)/
2When you enter your URL, you will be prompted with a login.
a. Username = Your “User Name” from Project Madeira, which may be different than your O365 account.
b. Password = Your “Web Service Access Key”
 Authentication Required

NOTE: Most versions of IE will give a message “Cannot display this feed.”

Cannot display feed

Using another browser such as Chrome will work to display/verify the feed:

Project Madeira in Power BI
Power BI Get Data – Connect to Project Madeira

With your Project Madeira OData service and authentication verified, you are ready to connect Power BI to Project Madeira:
1. Go to www.powerbi.com (sign-in with O365 credentials)
2. Get Data > Services

Power BI

3. Search for Project Madeira, click on Project Madeira and click Connect.
Project Madeira in Power BI

4. In the OData Feed URL, enter the URL you tested in the “Verify the OData URL is Accessible” step.

Connect to Project Madeira in Power BI
5. After clicking next this will ask for an Authentication Method.  Choose “Basic”, fill in the User name, Password and click Sign In.
a. Username = Your “User Name” from Project Madeira, which may be different than your O365 account.
  b. Password = Your “Web Service Access Key”

Connect to Project Madeira in Power BI

Importing data in Power BI

Power BI

Once imported, your Project Madeira dashboard will be accessible on Power BI.
Project Madeira in Power BI

Enjoy!

Related Posts

Recommended Reading:

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article
4.28.22 Dynamics GP

Uncommonly Used Features – Integrate Purchasing and Payables to Fixed Assets in Dynamics GP

Being able to integrate Purchasing and Payables to Fixed Assets in Dynamics GP will help you create visibility for your […]

Read the Article

New Features in the Dynamics 365 Business Central 2022 Wave 1 Release – Ease-of-Use Features

  There are many new features in the Dynamics 365 Business Central 2022 Wave 1 Release to get excited about! […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X