Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.