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

Need Help

2 Replies

  • 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