Forum Discussion
PowerBI Gateway log sql
I'm having problems with the Powerbi and sql management studio because I can't locate reports or datasets that weigh down my sql server with report queries that are no longer under my control I would like to sparer if there is a way to locate these queries using the dilog files of the powerbi gateway by cross-referencing with the sql activity monitor data
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
5 Replies
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
Yes yes I know, the problem is that in this way I don't get a way to identify the "heavy" queries that I have identified from the activity monitor of the sql server because in the powerbi logs (I think) the query that populates the single visual is shown or at least they have a different synassse and it is difficult for me to create a script to couple the queries from the logs and the queries from the activity monitor do you have any advice to give me??
For actual query impact you use the QueryExecutionReport logs.
