Forum Discussion
Lineage View - Datasets and Dataflows
- 5 years ago
I think you can build a script with the Power Bi Rest API. You can first take all the datasets:
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets_getdatasetsasadmin
Once you have those in a table or dataframe you can run for each one of them the request for data sources:
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets_getdatasourcesasadmin
After you organize your json response for each row you might be able to check the connectionString or connectionDetails looking for dataflows in order to see which datasets are using dataflows.
Hope that helps,
I think you can build a script with the Power Bi Rest API. You can first take all the datasets:
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets_getdatasetsasadmin
Once you have those in a table or dataframe you can run for each one of them the request for data sources:
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets_getdatasourcesasadmin
After you organize your json response for each row you might be able to check the connectionString or connectionDetails looking for dataflows in order to see which datasets are using dataflows.
Hope that helps,