Forum Discussion

shashi432's avatar
shashi432
New Member
6 years ago
Solved

How to gete power bi report sql (oracle database) query.

Can anyone please let me know, how to get the power bi report query. for e.g  I have created one report on power bi desktop  I wanted to see the corresponding sql  generated by this report.   alre...
Tutorial Requests
  • shashi432's avatar
    shashi432
    6 years ago

    Thanks Martyn,

     

     I am not using direct query mode, I'm using import query mode.

    Thanks for the link , yes I wanted to check my pbi report query performance; so as you have given me some guide link.

     

     I'll go through and let you know for any other issue. 🙂

     

     

MartynRamsden's avatar
MartynRamsden
Icon for Solution Sage rankSolution Sage
6 years ago

Hi shashi432 

 

If you're using Direct Query mode, you could capture the SQL queries being passed from Power BI to your Oracle database using your DBMS (e.g. Toad for Oracle).

 

However, if you're using import mode, there are no SQL queries generated once your data has been loaded; all queries passed to the Vertipaq engine are DAX.

If you want to capture the DAX queries generated as you interact with your report, you can use the 'Performance analyzer' within Power BI. This is a good guide: www.sqlbi.com/articles/introducing-the-power-bi-performance-analyzer/ 

 

Best regards,
Martyn


If I answered your question, please help others by accepting it as a solution.

 

 

 

shashi432's avatar
shashi432
New Member
6 years ago

Thanks Martyn,

 

 I am not using direct query mode, I'm using import query mode.

Thanks for the link , yes I wanted to check my pbi report query performance; so as you have given me some guide link.

 

 I'll go through and let you know for any other issue. 🙂