Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
rharrison2641
New Member

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

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):
Load_Error.PNG

 

 

 

 

 

 

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!

1 REPLY 1
v-yaningy-msft
Community Support
Community Support

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.