Forum Discussion
PowerBI Gateway log sql
Yes, you can consult the QueryStartReport log files on the gateway cluster members. They include the connection details, the query text AND the culprit (the dataset that initiated the query.
The query text is Base64 encoded.
The dataset is in the EvaluationContext column
For actual query impact you use the QueryExecutionReport logs.
No , my goal is to identify the queries that are weighing down my SQL server and they are queries "launched" by the user of the SQL gateway and by comparing the queries from the PowerBI logs and from the SQL Server Activity Monitor I can't identify them Do you have any solution to recommend?
Your main goal has to be to reduce the runtime of queries. Query duration is by far the most important KPI in Power BI. The QueryExecutionReport help provide data for that, including for all queries against your SQL server. You can also use the Fabric Capacity Metrics app to identify the long running queries and resource hoggers.