Connecting Power BI to Dynamics 365 for Free

Disclaimer: This will only work if you have a free or paid account to Microsoft Below are some resources you can utilize to get up and running on Microsoft Power BI.

Alright, time to connect Power BI to D365 for Financials. Below are the steps to connect over Financials OData:

1. Open Your online account

2. Select the Get Data option from the bottom menu

3. Click on the Get Service Option

Select Dynamics 365 for Financials from the list and click on "Get it Now"

New Connection window appears asking for the OData URL to connect

To get the OData url we need to open our D365 for Financials in either a new window or tab and then use the Global Search and search for the web service.

Select Power BI Reports Selection from list of objects.

Copy this url into the Power BI connection window

Your password is the web service access key of the Admin user and you can get it from the users tab.

So, after connecting to the financial OData services you should see a ready made dashboard created in Power BI for D365 for Financials.

And now we can embed this dashboard inside of D365 for Financials! On your home page click the Power BI Reports section header.

Then a list of reports should appear and you can select the one you'd like to see.

Are you looking for Microsoft Dynamics 365 for Financials support and training? Take a look at our Online Dynamics 365 University at

50 views0 comments
Contact Us

Solution Systems, Inc.

3201 Tollview Dr. 

Rolling Meadows, IL 60008

Office: 847-590-3000


Support: 224-345-2020

Support Email:

  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Microsoft Business Podcast
  • Manufacturing Software | Chicago
Find Quickly
Join our Mailing List

© 2020 Solution Systems, Inc.

Plain Email Signature Transparent.png