PowerBI service Gateway connection list

[nock97]

Hello, I was wondering if there was any way to export the the list in the admin portal that shows the reports, users, and respective gateways. By export I mean to an excel sheet or something similar to that. Also, if I was to remove a gateway from a report would I still be able to refresh the report? @Hela @help 

[collinq]

Hi @nock97 ,

The easiest way would be to use the API's, specifically, this one:  Gateways - Get Gateways - REST API (Power BI Power BI REST APIs) | Microsoft Learn

That will also allow you to refresh it at will.

[nock97]

Ok, I could just use Power Automate to pull the data and put it in the excel sheet correct? Or should I make a python script? @collinq @coco @Helper