Listing power bi reports connected to specific gateway connection

[srlabhe123]

Hi All,

I wanted to list down all Power BI reports connecting to a specific Gateway Connection.

Actually we wanted to remove certain connections from gateway cluster, but before that we need to have list of reports connecting to those connections so that we can alter the same on report level so that it does not fail to refresh?

Any suggestions here?

[v-kelly-msft]

Hi  @srlabhe123 ,

The Query Execution Report in Windows Performance Monitor tool can help realize it,for details,pls see below:

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[collinq]

HI @srlabhe123 ,

I think that you will have to investigate if you can do this with API's.  I am not sure if there is an easier way to find this.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!