I have a problem with Power BI reports with live connection to AAS tabular model. The table visuals suddenly stopped working in early November (and I didn't make any changes to the model and report at that time). The loading icon is visible until timeout, then it throws an error message “Visual has exceeded available resources”:
The problem occurs in several reports that are connected to the same model and also in one test report that is connected to a different AAS model.
I found out the issue is caused by measures that are added to these visuals. The purpose of these measures is to mask values in several columns (using RLS) without hiding other data from users.
I did some testing and my conclusions are as follows:
- The complexity of the measure does not matter (it can be a simple measure that returns “abc” string)
- If you add a measure to the visual where only one fact/dimension table is used – everything works fine
- The problem arises when columns from multiple tables are included in the visualization with measure:
- If the tables included are small, it takes a few minutes for the visualization to load (before the problem occurred it took only a few seconds to load)
- If the tables included are relatively big, the visual is loading forever and after some time (about an hour) it throws an error message “Visual has exceeded available resources”
The problem occurs both in the PBI service and desktop for all users.
Any ideas?
Hi @MartynaM
Based on your description, I think you need simplify your Measure, including simplify its calculation and the data amount. Meanwhile, you may use Performance Analyzer to help you identify how long your dax formula or data query will take. For more details, you can refer Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...
Best Regards,
Community Support Team _ Caiyun