• Michael Intravartolo

Connecting Power BI to Dynamics 365 for Free


Disclaimer: This will only work if you have a free or paid account to Microsoft PowerBI.com. 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 PowerBI.com 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 www.dynamics365university.com


Contact Us

Solution Systems, Inc.

3201 Tollview Dr. 

Rolling Meadows, IL 60008

Office: 847-590-3000

Email: info@solsyst.com

Support: 224-345-2020

Support Email: support@solsyst.com

Connect With Us
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Chicago
  • Manufacturing Software | Illinois
  • Microsoft Business Podcast
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago
Join our Mailing List

© 2020 Solution Systems, Inc.