none
OData: The feed's metadata document appears to be invalid RRS feed

  • Question

  • Hi experts,

    I'm trying to connect our Dynamics 365 (V9) instance to Power BI. After enter URL and user credentials, the above message is appearing. Could you anyone assist?


    Thanks,

    Digesh



    • Edited by Digesh_T Friday, May 4, 2018 11:15 AM
    Friday, May 4, 2018 11:13 AM

Answers

All replies

  • Hi Digesh_T,

    Have you tried to connect using the older version?

    Original API :-  https://organizationname.api.crm.dynamics.com/api/data/v9.0/ 

    Try the following :- https://organizationname.api.crm.dynamics.com/api/data/v8.1/ 

    Kind regards,
    Leon


    Please remember to mark the replies as answers if they help. - https://thesystemcenterblog.com -

    Friday, May 4, 2018 11:34 AM
  • Hi Digesh,

    I'm afraid we don't currently support the CRM 9.0 endpoint. You'll need to use one of the 8.* endpoints.
    Friday, May 4, 2018 11:21 PM
  • Hi Digesh,

    I'm afraid we don't currently support the CRM 9.0 endpoint. You'll need to use one of the 8.* endpoints.
    Hi,

    Do you realize neither of these work for 9.0 effectively leaving PowerBI dead in water for dynamics 9.0?

    We are in 9.0 and 8.2, 8.1, and 9.0 API's all result in the errors described above.
    Monday, June 25, 2018 8:14 PM
  • The June release of Power BI now supports CRM 9.0 by default, but conversely the new configuration now has an incompatibility with the metadata currently being returned by the 8.* endpoints. We are working with CRM on a long term fix. If you wish to continue using the 8.* endpoints in the meantime, you can revert to the old configuration with the following:

    1. If the Dynamics instance you wish to connect to is in your “Recent Sources” dropdown on the ribbon, then you can skip the other steps by creating a new connection through that; this will likely create a connection using the configuration from before the June release.
    2. Otherwise, go the “Get Data” dropdown on the ribbon and click on “Blank Query”.
    3. In the window that appears, go to the formula bar under the ribbon and enter:
    = OData.Feed("[Your CRM endpoint URL]")

    replacing [Your CRM endpoint URL] with the URL you would normally connect to.

    1. Hit enter. You will see a table appear listing the feeds you have access to. Find the row containing the feed you wish to load, and then click on the “Table” cell in the same row.
    2. You will now be where the CRM connector would normally drop you off when you choose to “edit” your query after initially creating it. If you wish to apply any transformations, you may now do so as you normally would. Otherwise you can load the query into Power BI Desktop by clicking on the “Close & Apply” button in the ribbon.
     
    Tuesday, June 26, 2018 4:58 PM
  • Hi Tim and Dig,

    I just got it to work:

    old = OData.Feed("https://d365_instance.api.crm3.dynamics.com/api/data/v8.2")
    new = OData.Feed("https://d365_instance.api.crm3.dynamics.com/api/data/v9.0", null, [Implementation="2.0"])

    this is what you need:

    , null, [Implementation="2.0"]

    8.2 or 9.0 seem to work after getting lots of metadata error messages! :)

    Tuesday, July 10, 2018 7:19 PM