Forum Discussion
Do hidden visuals impact performance
Hi Anonymous ,
By Default all queries in Power Query will be loaded into the Power BI model, and consume memory. Even when you hide visual ,the query will still consume the memory and affect performance. The best approach is to disable loading in Query Editor. select the query and right click, Click on the Enable Load to disable it, then click "Apply &Close", the query won't been seem in Report View, Data View, and Model View.
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, or when a scheduled refresh happens even queries marked as Disable Load will be refreshed, but their data will be used as intermediate source for other queries instead of loading directly into the model.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
By Default all queries in Power Query will be loaded into the Power BI model, and consume memory. Even when you hide visual ,the query will still consume the memory and affect performance. The best approach is to disable loading in Query Editor. select the query and right click, Click on the Enable Load to disable it, then click "Apply &Close", the query won't been seem in Report View, Data View, and Model View.
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, or when a scheduled refresh happens even queries marked as Disable Load will be refreshed, but their data will be used as intermediate source for other queries instead of loading directly into the model.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.