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?
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.
Find out who won the T-Shirt Design Challenge and the top 3 finalists.
Find out more about the March 2023 update.
