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