Forum Discussion

Willgart's avatar
Willgart
Helper II
9 years ago

How to get the generated SQL statement in directquery mode?

Hi,   how I can get the generated SQL statement in powerbi in directquery mode without using the SQL profiler? I want to see the generated SQL code and diagnose the queries, but I cant use the pro...
Need Help
Willgart's avatar
Willgart
Helper II
9 years ago

Sorry, I cant use snything from the SQL Server side. its SQL 2008R2, and I'm not admin and I have not the rights to see the activity at the server level.

I need a powerbi side solution.

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    Willgart

     

    Currently there is no such feature on PBI side can meet your requirement. Maybe you can vote it in the idea site.

     

    Best Regards,

    Herbert