Forum Discussion
Unable to refresh a Dynamics 365 Datasource via gateway
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,
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
3 Replies
v-yalanwu-msftCommunity Support
Hi, Chad1234 ;
You can check if these related post can is useful to you.
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.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
Thank you, this resolved it!