Forum Discussion

mike_asplin's avatar
mike_asplin
Helper V
4 months ago
Solved

OData source error

Hi   I have amodle that did have some OData sources, but i changed them all to CDS sources. So now i just have CDS, shareoint excle files and a public website. Even so when I try to refresh in serv...
Need Help
  • mike_asplin's avatar
    mike_asplin
    3 months ago

    all good

v-aatheeque's avatar
v-aatheeque
Community Support
3 months ago

Hi mike_asplin 

The query you are using is indeed an OData query because the Dynamics 365 / Dataverse API exposes data via the OData v9.1 endpoint. Even though you are calling it with Web.Contents the $select and $filter options are OData system query options.

 

Microsoft recommends using the Dataverse connector in Power BI Desktop instead of manually calling the OData feed. The connector handles authentication and schema more reliably and avoids errors like DMTS_OAuthFailedToGetResourceIdError.

 

Hope this helps!!

Thank You.

 

 

v-aatheeque's avatar
v-aatheeque
Community Support
3 months ago

Hi mike_asplin 

Just following up to see if everything is working fine after switching to the CDS connector.
Please let me know if you still have any questions or need help validating the setup.

  • mike_asplin's avatar
    mike_asplin
    Helper V
    3 months ago

    all good

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    3 months ago

    Hi mike_asplin 

    Glad to hear everything is working fine now!

    If any of the suggestions helped, please acknowledge any of the solution so it can help others in the community who will face a similar issue.

     

    Thank You.