Forum Discussion

wfrohwein's avatar
wfrohwein
Frequent Visitor
3 years ago

Salesforce Object with many records causing long load times

I have a salesforce account object 4+ million records and soon to be 8 million. When i first created my dashboard, the account object only had about 200,000 records in it. The dashboard was nice and ...
Need Help
v-jialluo-msft's avatar
v-jialluo-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi  wfrohwein ,

 

According to your description, your problem is that large data sets refresh too slowly.

You can try the incremental refresh feature to configure incremental refresh for tables with large data volume to optimize refresh efficiency, please refer to the following links:

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

 

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

wfrohwein's avatar
wfrohwein
Frequent Visitor
3 years ago

I have another question for you. In the documentation i read this "Query folding - Incremental refresh is designed for data sources that support query folding". As i understood it, The salesforce objects connector does not support query folding. So in theory that means that incremental refresh would not work correct? Not without maybe putting all the data in azure sql server database or something similar that supports query folding?