Forum Discussion
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>...
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