Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
You can connect to Microsoft Dynamics 365 (online) with Power BI Desktop to create Dynamics 365 reports and dashboards for use with the Power BI service.
Power BI service registration
Microsoft Dynamics 365 (online) instance
Start Power BI Desktop.
From the Home tab, click Get Data, and then click More.
In the Get Data list, select Dynamics 365 Online.
Enter the Dynamics 365 (online) OData endpoint URL. It should look similar to this URL, where OrganizationName is the name of your Dynamics 365 (online) organization, and v8.1 is the version. Click OK.
You can find your OData endpoint URL in the Microsoft Dynamics 365 web client. Go to Settings > Customizations > Developer Resources and locate the URL under Instance Web API. |
In the Access an OData feed dialog click Organizational account, and then click Connect.
Note
If you aren't signed in to your Microsoft Dynamics 365 (online) instance, click Sign-in on the Access OData feed dialog before you click Connect. |
The organization database tables appear in the Power BI Desktop Navigator window. For more information about creating reports with Power BI Desktop, see Power BI Support: Report View in Power BI Desktop.
Tip
You can use similar steps to connect to Microsoft Dynamics 365 (online) using Microsoft Office Excel Power Query by selecting From Other Sources on the Power Query tab in Excel. |
Source: Technet
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |