Forum Discussion
powerbiexpert22
Impactful Individual
Impactful Individualvisual has exceeded resources error
I am getting error "Visual Has Exceeded The Available Resources" in power bi report. I am using composite model ( facts are on direct query mode and dimensions are import mode). how i should troubles...
Greg_Deckler
Community Champion
Community Championpowerbiexpert22 Generally this kind of thing is caused by a DAX measure. You can use Performance Analyzer to view the DAX query. You could also run a SQL Trace to capture what query is hitting the SQL server.
powerbiexpert22Hi Greg_Deckler , how to run sql trace?
Thanks for the reply from Greg_Deckler and rajendraongole1 .
powerbiexpert22 , You can use SQL Server Profiler to run SQL trace.
SQL Server Profiler - SQL Server Profiler | Microsoft Learn
Run SQL Server Profiler - SQL Server Profiler | Microsoft Learn
Best Regards,
Yulia Xu