visual has exceeded resources error

[powerbiexpert22]

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 troubleshoot this issue ? can it be possible to extract the sql query behind specfic visual in power bi?  

[rajendraongole1]

Hi @powerbiexpert22 - Please check the solution thread of similar issue.

Solved: Visual Has Exceeded the resources error - Microsoft Fabric Community

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Greg_Deckler]

@powerbiexpert22 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.

[powerbiexpert22]

Hi @Greg_Deckler , how to run sql trace?

[Anonymous]

Hi @powerbiexpert22 

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