Forum Discussion

Petja's avatar
Petja
Icon for Advocate II rankAdvocate II
1 month ago
Solved

How to use DirectQuery table with complex visuals

Hi,   I'm doing a report which has quite complex visuals; multiple field parameters and relationships. I also have a very large data set, which causes the report to run out of memory if I don't red...
Need Help
  • v-sathmakuri's avatar
    v-sathmakuri
    26 days ago

    Hi Petja​ ,

    Sorry for the delay in response.

    Yes. If Performance Analyzer doesn't expose the query because the visual fails, you can capture it from the Power BI Desktop trace.

    Go to File → Options and settings → Options → Diagnostics → Open crash dump/traces folder. Then locate the active AnalysisServicesWorkspaces folder and open FlightRecorderCurrent.trc.

    If the source is SQL Server, you can also use SQL Server Profiler to capture the query directly at the database side.

    Thanks!!

Praful_Potphode's avatar
Praful_Potphode
Icon for Super User rankSuper User
1 month ago

Hi Petja 

Can you share the information about your data model ,SQL Queries and Source.

Based on athe information, you can simplify your model by aggregating data,creating materialized views etc.

these all options depend on what your data model and source looks like.

Please give kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful