Forum Discussion
Slow Refresh Power BI Desktop - Excel File
Hi NAMI1356,
I don't know your data structure in details, so it's hard to find the exact cause. If you go to the Task Manager, how many Microsoft.Mashup.Container*.exe can you find there, and are any of them busy?
I share some tips, please follow them and check if it works fine.
1. Disable "Backgroud data" and "parallel loading of tables" in current files under options.
2. If you files have many columns of date/time type, you can disabled Data Load -> Auto Date/Time, so behind the scenes it doesn't create a date table automatically, which takes time. Disabling the auto date/time feature means you'll probably need to manually create a date table in the model.
3. Please disable load query like the following screenshot. Disabling Load doesn’t mean the query won’t be refreshed, it only means the query won’t be loaded into the memory. When you click on Refresh model in Power BI, their data will be used as intermediate source for other queries instead of loading directly into the model.
4. You can filter your resource table and just retain the neccesary data before you load all the data into model.
In addtion, you can follow those two articles to optimize data model to improve the performance:
Data Import Best Practices in Power BI
Power BI Performance Tips and Techniques
Best Regards,
Angelia
Hi NAMI1356,
I don't know your data structure in details, so it's hard to find the exact cause. If you go to the Task Manager, how many Microsoft.Mashup.Container*.exe can you find there, and are any of them busy?
I share some tips, please follow them and check if it works fine.
1. Disable "Backgroud data" and "parallel loading of tables" in current files under options.
2. If you files have many columns of date/time type, you can disabled Data Load -> Auto Date/Time, so behind the scenes it doesn't create a date table automatically, which takes time. Disabling the auto date/time feature means you'll probably need to manually create a date table in the model.
3. Please disable load query like the following screenshot. Disabling Load doesn’t mean the query won’t be refreshed, it only means the query won’t be loaded into the memory. When you click on Refresh model in Power BI, their data will be used as intermediate source for other queries instead of loading directly into the model.
4. You can filter your resource table and just retain the neccesary data before you load all the data into model.
In addtion, you can follow those two articles to optimize data model to improve the performance:
Data Import Best Practices in Power BI
Power BI Performance Tips and Techniques
Best Regards,
Angelia
Thanks for you help Angelia,
For : Microsoft.Mashup.Container*.exe
CPU Usage:40%
Memory Usage>260MB
for Change the settings we do as your assistance.
Thank you.
Nami
Hi NAMI1356,
After changing all the settings, the CPU Usage:40% and Memory Usage>260MB, your resource is large? If you have resolved your issue? Please mark the right reply as answer, so more people will benefit from here.
Best Regards,
Angelia