Forum Discussion
Appending queries extremely slow (source: Salesforce Objects)
Hi, I need some help. I have researched slowness in Power BI and turned off automatic connections and loading for underlying queries. The new appended query would be the only one that I need to load into the visuals. But, it takes an extremely long time to run. It's confusing because each of the underlying queries are relatively small, all less than 500 rows and load rather quickly. (No major calculations being done here. Mainly file clean up from Salesforce.) There are nine queries that I am appending into the one larger query that I am using. Sometimes, the file will even crash my laptop. Any thoughts on what I am doing wrong here or what I could do differently?
Thanks for considering.
Hi,
Thank you for following up. No, unfortunately. But, I think I did find the solution to my issue.
1) I shut off data previews in the background
2) I shut off parallel loading of tables
I believe the issue is caused by the fact that Power BI forces you to load the entire object even if you only need some portion of that object. I voted up this issue with Power BI and request that everyone interested in this issue do the same. Thanks for your time and help.
3 Replies
Hi,
Thank you for following up. No, unfortunately. But, I think I did find the solution to my issue.
1) I shut off data previews in the background
2) I shut off parallel loading of tables
I believe the issue is caused by the fact that Power BI forces you to load the entire object even if you only need some portion of that object. I voted up this issue with Power BI and request that everyone interested in this issue do the same. Thanks for your time and help.
This seemd to do the trick for me - Thank you!
