How to resolve OLE DB or ODBC timeout error when pulling in a large object from Salesforce

[rharrison2641]

Hello,

I will preface this by saying that I am new to PowerBI, but experienced in Salesforce. I am trying to pull in several objects into a PowerBI report by going to Get Data>Salesforce Objects>Custom.

The problem I'm having is that there are hundreds of thousands of rows related to the specifc object I am trying to pull in. I understand that this is an error we get when (the DB or PowerBI? Not sure) times out (the timeout occurs after about 5-10 min of trying to pull in the object):

Does anyone know the best way to solve this problem, specifically related to Salesforce? I read that I should adjust the timeout settings in the DB I'm pulling from (in this case, Salesforce), but I'm not too sure how to do this.

Any help would be much appreciated!

[v-yaningy-msft]

Hi, @rharrison2641 

It is best to follow these rules when pulling data:

1. Clear the catche in the desktop file

2. Dont load entire data load only required amount of columns and rows from DB.

3. Dont load all the tables at once, load one by one tables

4. Turn off auto detect relationships in options this will also impact the time. 

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum