Forum Discussion
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...
luisrh
Responsive Resident
Responsive ResidentI 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.
For import mode, is it possibile to log sql/dax queries from Reports on Report Server?