Currently, the Power BI service isn’t compatible with the Dynamics 365 (online) version 9.0 OData endpoint. When you try to use the version 9.0 OData endpoint with the Power BI service the error message “The feed’s metadata document appears to be invalid” is displayed. To work around this incompatibility, use the Dynamics 365 (online) version 8.2 OData endpoint

Power BI Desktop – Connect to Dynamics 365 Online

  • Launch Power BI Desktop
  • Click on Get Data from Home menu
  • Click on More and Dynamics 365 (Online) under All
  • Click Connect
  • Enter OData endpoint URL in below format “https://orgname.api.crm.dynamics.com/api/data/v<8.0 or 8.1 or 8.2>
  • Do not enter v 9.0 even if you are working with latest version of Dynamics 365. Use v8.2 instead.

If you enter v9.0 above, you will see below error:

1

Reference:

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/admin/use-power-bi