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.
HI, we have some datasources under a specific gateway. We want to know which reports/datasets are connected to these datasources if there are any? How to find that information. Because we want to remove that gateway and want to notify the users using those reports..
@v-lili6-msft I have the exact same question
"HI, we have some datasources under a specific gateway. We want to know which reports/datasets are connected to these datasources if there are any? How to find that information. Because we want to remove that gateway and want to notify the users using those reports.."
I have been looking around for the answer and your post does not seem to answer the question - I have seen some API's but they do not seem to help.
I need to - have the datasource and the related dataset in the same report so I can see which dataset is using which dataset- so we can remove any datasources which are no longer being used - but currently we are unable to do this as we only have an API which provided a
-https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasources-as-admin
datasource and related gateway (List of all of them)
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasets-as-admin
- dataset
But the only API we can find give you an individual report but does not include a report / dataset id - we need to see all of them -
Are you able to help
Thanks
Karen
hi, @Anonymous
I think you may try this way:
In Power BI service, go to the dataset management page (gear icon in top right->Manage personal storage). This will give you the list of datasets and for each dataset it will show relative gateway information under 'Gateway connection'.
Best Regards,
Lin
hi, @Anonymous
You could also get it from settings ->Datasets to check which dataset is run under the gateway
Best Regards,
Lin
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.