Forum Discussion

kemal's avatar
kemal
New Member
9 years ago

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...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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?:smileyhappy:

 

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's avatar
    kemal
    New Member
    9 years ago

    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