Showing results for 
Search instead for 
Did you mean: 
New Member

Gateway sources cleanup

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


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





Resolver II
Resolver II

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. 

Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Solution Authors