How to Integrate Power BI with Dynamics 365 for Operations

By Warren Young | May 4, 2016

How to integrate power bi with dynamics 365 for operations

This post will cover how to integrate your Dynamics 365 for Operations instance directly with Power BI (free version).

As the current deployment model for Dynamics AX is Azure-hosted, authenticating with Power BI does not need to involve any of the Power BI Gateways.  It does use a slightly different authentication method than Power BI with Dynamics NAV, or Power BI with Project Madeira, but we’ll cover those steps below.

Financial Performance

Power BI

 

Retail

Power BI

 

Prerequisites

  1. Dynamics AX (AX7) instance and login with permissions to read the OData feeds
  2. Office 365 Account with Power BI (free)

Note: It is acceptable for the login for Dynamics AX to be different from the login for Office 365 / Power BI.  In most live deployments these would be the same using the single sign-on feature, but it is not required.

 

Contents

Verify User Account to Dynamics AX

Verify Data Entities Are Accessible

Power BI Get Data – Connect to Dynamics AX

 

Verify User Account to Dynamics AX

  1. Use a web browser to log-in to your Dynamics AX instance.  (The URL should look something like .cloudax.dynamics.com)
  2. You will be presented with a login for a username and password (this login will be used later in this process) and, once entered, will be brought to the Dynamics AX home page:

New Dynamics AX

 

Verify Data Entities Are Accessible

  1. In the same session, add /data/ to the base URL, the result should look like:   .cloudax.dynamics.com/data/
  2. That should open an XML feed of different data entities available in your Dynamics AX instance.

In my case, IE downloaded the feed as a file and I opened it in notepad for demonstration purposes.  Note that this is not necessary other than to verify your account has appropriate permission to access the feed.

 Data Notepad

 

Power BI Get Data – Connect to Dynamics AX

With your Dynamics AX data service and authentication verified, you are ready to connect Power BI to Dynamics AX:

  1. Go to www.powerbi.com (sign-in with O365 credentials)
  2. Get Data > Services

Power BI with new Dynamics AX

  1. Search for Dynamics AX, click on either Financial Performance or Retail Performance (you can repeat this process to get both) and click Connect.

Power BI with the new Dynamics AX

  1. Environment URL, enter the base URL (without /data/ at the end), i.e.: .cloudax.dynamics.com and click Next

Connect to Microsoft Dynamics AX Retail channel performance

  1. After clicking next this will ask for an Authentication Method.  Choose “oAuth2”, and click Sign in.  This will open a new login page to sign into your Dynamics AX instance.

Connect to Microsoft Dynamics AX Retail Channel Performance

  1. Fill in the Username, Password and click Sign In.  (Login is the same as what you use to login to Dynamics AX, which may be different than your Power BI login.)

Power BI login Office 365

Once authenticated, Power BI will start importing and set up your dashboard.

Importing data in Power BI

Data successfully imported in Power Bi

Once imported, your Dynamics AX dashboard will be accessible on Power BI.

Power BI in new Dynamics AX

Enjoy!

For More Information

https://ax.help.dynamics.com/en/wiki/powerbi-integration-in-ax7/

https://ax.help.dynamics.com/en/wiki/how-to-create-a-powerbi-report-using-ax-data/

https://powerbi.microsoft.com/en-us/blog/explore-your-dynamics-ax-data-with-power-bi/

Related Posts

Recommended Reading:

5.27.22 Dynamics GP

How to Run Drop Ship Sales in Dynamics GP

Need to Invoice the Customer before you get the invoice from the vendor? This The freight forwarder has contacted you […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Protecting G/L Accounts From Being Deleted

There are a lot of exciting New Features in Dynamics 365 Business Central 2022 Wave 1 Release to get excited […]

Read the Article
5.25.22 Financials

Rounding Numbers in Power Automate

  If you’ve ever tried to round numbers in Power Automate, you have probably already run into the issue there […]

Read the Article

Manage U.S. Use Tax on Purchase Orders in Dynamics 365 Finance and Operations

  Managing sales tax requirements on your business purchase can be complicated, but Dynamics 365 Finance and Operations can help […]

Read the Article
5.19.22 Dynamics CRM

How to Write a Great Support Ticket in the Stoneridge Support Portal

Submitting a support ticket through the Stoneridge Support Portal is a quick and effective way to get assistance for any […]

Read the Article

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

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