Forum Discussion
Visual exceeds available resources, but not when published
Hello,
I'm making a table visual with PowerBI Desktop on my laptop, and I get the error "Visual exceeded the available resources".
However, when I publish this report online, the table just loads perfectly.
Does anyone know if my laptop might not be strong enough, or might there be other issues?
Thanks in advance
Hi, Anonymous
According to your description, you have encountered the Resources Exceeded issue, which usually occurs when refreshing data, loading large datasets, or performing complex calculations, you can try the following methods to resolve your problem:
- Optimize the data model by minimizing the number of columns in the table and using appropriate data types.
- Optimize DAX expressions and avoid resource-intensive functions such as EARLIER() or FILTER().
- Clear the Power BI Desktop cache by going to File > Options and Settings > Options > Data Load > Clear cache. Clearing the Power BI Desktop Cache
- Ensure that you are using the latest version of Power BI Desktop.
- It is also possible that the local computer is running out of content space. Use Task Manager to monitor CPU and memory usage when loading visual objects in Power BI Desktop, and if the local memory is full, you can either upgrade laptop appropriately or turn off unneeded app on the local computer when you use Power BI Desktop
Related Link: Solved: Service: Visual has exceeded available resources. ... - Microsoft Fabric Community
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
Hi,
I think that this anwer might be perfect for you:
Hi, Anonymous
According to your description, you have encountered the Resources Exceeded issue, which usually occurs when refreshing data, loading large datasets, or performing complex calculations, you can try the following methods to resolve your problem:
- Optimize the data model by minimizing the number of columns in the table and using appropriate data types.
- Optimize DAX expressions and avoid resource-intensive functions such as EARLIER() or FILTER().
- Clear the Power BI Desktop cache by going to File > Options and Settings > Options > Data Load > Clear cache. Clearing the Power BI Desktop Cache
- Ensure that you are using the latest version of Power BI Desktop.
- It is also possible that the local computer is running out of content space. Use Task Manager to monitor CPU and memory usage when loading visual objects in Power BI Desktop, and if the local memory is full, you can either upgrade laptop appropriately or turn off unneeded app on the local computer when you use Power BI Desktop
Related Link: Solved: Service: Visual has exceeded available resources. ... - Microsoft Fabric Community
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
