Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Chad1234
Frequent Visitor

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,

 

1 ACCEPTED SOLUTION
Arenddeux
Regular Visitor

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

View solution in original post

3 REPLIES 3
Arenddeux
Regular Visitor

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!

v-yalanwu-msft
Community Support
Community Support

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors