PowerBi – Dynamics 365

How to add custom fields to your power bi datasets.
As we know this is not supperted in powerbi online.
Found a neat little trick.
Get Power BI desktop
Add Data From Dynamics 365.

 image

Go to developer resources in Dynamics 365
Copy the url to the organization service: for me that was https://edupoint.api.crm4.dynamics.com/XRMServices/2011/Organization.svc
Edit
and make the endpoint OrganizationData.svc

 image

Connect. Presto! You now have access to your custom field data.

 image

Eport your dataset to powerbi online.