Gateway sources cleanup

[parscot]

We have a lot of gateway data sources and many arent used any more. In other words, they arent referenced by a dataflow or dataset in our tenant on PowerBi.com

How can i generate a list of data sources which arent references by a dataflow/dataset?

[m-colbert]

Using the Power BI REST API you can get a list of datasources for dataflows and datasets and use this info to filter through them. A quick way of doing this is to build a report using the Power BI REST API custom connector found here. GitHub - migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector fo...

You can get gateways and thier datasources and link them to the datasources for datasets and daatflows. 

Hope this helps.