Using Dynamics 365 as a Power BI Data Source
You can make your Dynamics 365 data available as a data source in Power BI and build powerful reports of the state of your business.
You must have a valid account with Dynamics 365 and with Power BI. Also, you must download Power BI Desktop.
To add Dynamics 365 as a data source in Power BI Desktop
- In Power BI Desktop, in the left navigation pane, choose Get Data.
In the Get Data window, choose Online Services, choose Dynamics 365 Business edition **, and then choose the **Connect button.
Power BI displays a wizard that will guide you though the connection process. The first step will be to enter an OData URL and the company name that is associated with your Dynamics 365 account.
For the OData URL, you can copy the OData V4 URL of any of the web services that are listed in the Web Services page in Dynamics 365, such as
For the Company Name, use the name that is shown in the Name field in the Company Information window in Dynamics 365. If your Dynamics 365 contains multiple companies, choose the relevant company name from the list in the Companies window. In both cases, make sure that the name that you specify in the Power BI wizard matches exactly the text shown in Dynamics 365, such as
Once you have entered the information, choose the OK button. The next step in the wizard will be to enter your username and password.
If there are other authentication options available in the left hand navigation, choose Basic.
Enter your username and password. You can find this information in the Users window in Dynamics 365. Use the Web Access Key as your password.
For example, your username is ADMIN, and the web service access key that serves as your password is EgzeUFQ9Uv0o5O0lUMyqCzo1ueUW9yRF3SsLU=.
Choose the Connection button to continue. The Power BI wizard shows a list of Dynamics 365 data sources. These data source represent all the web services that you have published from your Dynamics 365.
Alternatively, create a new web service URL in Dynamics 365 by using the Create Data Set action in the Web Services page, using the Set Up Reporting Assisted Setup guide, or by choosing the Edit in Excel action in any lists.
Specify the data you want to add to your data model, and then choose the Load button.
Repeat the previous steps to add additional Dynamics 365 data to your Power BI data model.
Once you have successfully connected to Dynamics 365, you will not be prompted again for the OData URL, username, or password.
Once the data is loaded it will appear in the right navigation on the page. At this point, you have successfully connected to your Dynamics 365 data and are ready to begin building your Power BI report. For more information, see the Power BI documentation.