The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
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!!
Proud to be a Super User! | |
@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.
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