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 profiler.

 

thanks.

 

Need Help

3 Replies

    • 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