Unable to load some visualisations

Hi, ATO23 

Your product has a large number of string fields, and the number of rows of data reaches three million, and the query or computation that runs consumes more memory than the configured limit.

You can check if your query can be simplified. Avoid complex calculations or extensive data transformation steps. Simplifying queries can reduce memory usage.

Examine your data model to see if there is unnecessary complexity or non-standard data structures, and try to optimize your data model.

Consider using paginated reports, which can handle large amounts of data and are handled differently than interactive reports.

For optimization, you can refer to the following link:

Optimization guide for Power BI - Power BI | Microsoft Learn

Optimize a model for performance in Power BI - Training | Microsoft Learn

Or contact your capacity administrator to ask if you can increase the memory limit for your query, and you can check out the following links for capacity limits:

What is Power BI Premium? - Power BI | Microsoft Learn

How to configure workloads in Power BI Premium - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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