Is there a way to find out which reports are using a specific datasource?

[Anonymous]

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..

[KarenL7]

@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

[v-lili6-msft]

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

[Anonymous]

@v-lili6-msft   where do u see 'gateway connection'? i dont  find it..all i see is this...

[v-lili6-msft]

hi, @Anonymous 

You could also get it from settings ->Datasets to check which dataset is run under the gateway

Best Regards,

Lin