Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hi @NISH72 ,
The error occurs when a visual attempts to query too much data for the server to complete the result with the available resources. You may need to filter the visual to reduce the amount of data in the result currently. That way, the error might be resolved.
Please set schedule refresh for different datasets at different times, and make sure that you are using the latest version of gateway.
Please make sure that you don't schedule more than max parallel refreshes for the different nodes in these capacities. Also we suggest that you first disable all refreshes on all capacities. Then slowly enable the refreshes one by one. Make sure refreshes are staggered apart (e.g. 1 hour apart), and that no more than max concurrent refreshes happen at overlapping time periods.
You can also optimize your data model following the guide in the blogs below, and re-publish your PBIX file to Power BI Service.
Power BI Performance Tips and Techniques
Data Import Best Practices in Power BI
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @NISH72 ,
The error occurs when a visual attempts to query too much data for the server to complete the result with the available resources. You may need to filter the visual to reduce the amount of data in the result currently. That way, the error might be resolved.
Please set schedule refresh for different datasets at different times, and make sure that you are using the latest version of gateway.
Please make sure that you don't schedule more than max parallel refreshes for the different nodes in these capacities. Also we suggest that you first disable all refreshes on all capacities. Then slowly enable the refreshes one by one. Make sure refreshes are staggered apart (e.g. 1 hour apart), and that no more than max concurrent refreshes happen at overlapping time periods.
You can also optimize your data model following the guide in the blogs below, and re-publish your PBIX file to Power BI Service.
Power BI Performance Tips and Techniques
Data Import Best Practices in Power BI
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is the above tips and tricks apply both for direct query and import ? if i change from direct query to import when facing the Visuals exceed memory issue will it help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.