is there a way to see which power bi reports are using which power bi gateway connection?

[hmeltonPSL]

is there a way to see which power bi reports are using which power bi gateway connection?  I am trying to shutdown a gateway and I need to know which datasets and reports are using the gateway.

Thank you

[pb_amk · Accepted solution]

Hi. @hmeltonPSL 

First, open the workspace. It opens list view by default which contains reports and datasets.

On the far left, below Workspace settings, you will see two icons: one for List view and one for Lineage view. Switch to Lineage view It shows a mapping datasource-Semantic Model -report.

Note down which semantic models or reports are using each data source.

Next, go to Settings > Manage data gateways and connections > Connections tab. In this section, you will find a table that contains Name | Connection Type | Users| Status| Gateway cluster

Based on your notes and and  table in the connection tab. You can easily get to know, which gateway each report using.

If this found helpful, Please mark it as a solution. Thank you.

[GilbertQ · Accepted solution]

Hi @hmeltonPSL 

You can also use the Scanner API data which will tell you when you extract it, you can find out which report use which data sources.

You can also use the Power BI API here: Datasets - Get Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[pb_amk · Accepted solution]

Hi. @hmeltonPSL 

First, open the workspace. It opens list view by default which contains reports and datasets.

On the far left, below Workspace settings, you will see two icons: one for List view and one for Lineage view. Switch to Lineage view It shows a mapping datasource-Semantic Model -report.

Note down which semantic models or reports are using each data source.

Next, go to Settings > Manage data gateways and connections > Connections tab. In this section, you will find a table that contains Name | Connection Type | Users| Status| Gateway cluster

Based on your notes and and  table in the connection tab. You can easily get to know, which gateway each report using.

If this found helpful, Please mark it as a solution. Thank you.