Dynamics 365 OData Time-out

[kemal]

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?

[v-ljerr-msft]

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?

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]

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