Unable to refresh a Dynamics 365 Datasource via gateway

[Chad1234]

Good morning,

I have created a report in Power BI Desktop that connects to our Dynamics 365 instance which refreshes correctly using the desktop client, but when I upload it to the Power BI service and schedule a refresh I get an error. 

The connector I am using is "Dynamics 365 (online)", and the web API URL is "https://XXX.api.crmXX.dynamics.com/api/data/v9.2/"

The error produced when the refresh fails is:

Underlying error code: -2147467259

Underlying error message: OData: The given URL neither points to an OData service or a feed: 'https://login.microsoftonline.com/50f6071f....'

I have tried using both Basic and Widows auth with comparable results.

How would I go about rectifying this issue?

Thank you,

[Arenddeux · Accepted solution]

Try using the Dataverse connector instead.  I found it to refresh faster and easier to use.  I was facing a similiar issue where the online PBI service was timing out.  With the Dataverse connecter the refreshes are faster and even working in the query I found it easier.  Of course the tradeoff is I had to rebuild the model, wasnt too difficult, just some naming changed for columns.

Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Docs

[Chad1234]

Thank you, this resolved it!

[v-yalanwu-msft]

Hi, @Chad1234 ;

You can check if these related post can is useful to you.

https://community.powerbi.com/t5/Desktop/OData-The-given-URL-neither-points-to-an-OData-service-or-a...

https://community.powerbi.com/t5/Service/Refresh-error-message-Information-is-needed-in-order-to-com...

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.