cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kemal Frequent Visitor
Frequent Visitor

Dynamics 365 OData Time-out

Hi all!

 

I'm having troubles loading big data with the OData method from Dynamics 365. I've searched the forum but couldnt find anything except a timeout definition rule for web services. 

 

The problem arises when PB Desktop tries to import a table with millions of rows. It shows : OLE DB or ODBC error: [DataSource.Error] OData: Request failed: The operation has timed out...

 

I have done lots of optimizations like using reference queries to merge instead of the base tables, excluding all unnecessary columns from the base tables to minimize data load, disabling all lead settings to do a 1 by 1 load/evaluation etc.

 

Does anyone has experience with this error?

2 REPLIES 2
Microsoft v-ljerr-msft
Microsoft

Re: Dynamics 365 OData Time-out

Hi @kemal,


I'm having troubles loading big data with the OData method from Dynamics 365. I've searched the forum but couldnt find anything except a timeout definition rule for web services


So you do have tried adding an option to the OData.Feed function to increase the timeout, but you still get the same error?Smiley Happy

 

To set it to (e.g.) five minutes, you need to manually edit the formula for the function in Advanced Editor and add the Timeout option like this:

= OData.Feed("http://some.url/service.svc/", null, [Timeout=#duration(0, 0, 5, 0)])

 

Regards

kemal Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData Time-out

Hey @v-ljerr-msft,

 

Sorry for my late reply.

 

Thank you for sharing your solution, but i did try that before but it didn't work. I am doubting if it is a Power BI problem, cloud connection problem or a Dynamics 365 problem.

 

We are trying direct odata links for every table by filtering in the URL on the columns. Maybe that will speed it up...

 

Is there is any other way to optimize Power BI Desktop..? 

 

Greetings

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)