Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How To Find SQL Queries from Report on Report Server

Hi,   I have published report to Power BI Report Server (on-premise) and would like to analyse SQL queries fired by the report to fine tune my model. There are multipe views and the model is comple...
Direct Query
DirectQuery
Report Server
Report Server Execution Log
luisrh's avatar
luisrh
Responsive Resident
7 years ago

I assume you are using Directquery on Power BI report.   Either way the best way to manage this is to run SQL profiler on the database in use.  I would filter the values on the trace to ones coming from the report server.   That is the best way to get what you are looking for.   If it's an SSRS report,  I have found that to be the best way to get the details you need.

 

  • jay-jay's avatar
    jay-jay
    Frequent Visitor
    5 years ago

    For import mode, is it possibile to log sql/dax queries from Reports on Report Server?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    luisrh 

    Thank you for the reply.

    Yes. I m using Direct Query Mode.

     

    For import mode, I find it easy to check using built in Performance Analyser. DAX Studio is also an option.

     

    Thanks,

    Mannu