topic API to get list of reports using a specific dataset in Developer

API to get list of reports using a specific dataset

gotters — Sun, 25 Sep 2022 08:14:58 GMT

Is there an easy way to fetch a list of reports that are using a specific dataset in the workspace?

The same way in Power BI Service when you click on a dataset it shows you the list of associated reports.

Obviosuly I could pull all reports in the workspace which includes the dataset Id but I am trying to avoid that and just want an API which will filter this.

Please advise if there is a way

Re: API to get list of reports using a specific dataset

v-chenwuz-msft — Mon, 26 Sep 2022 05:45:13 GMT

Hi @gotters ,

You can try this REST API:

Reports - Get Reports In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

This will return all the reports in the workspace. And in the response body, it will contain the datasetid.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: API to get list of reports using a specific dataset

gotters — Tue, 27 Sep 2022 19:03:14 GMT

Thanks, thats what i referred to above. I was hoping there was a more efficient way to specifically filter the request by dataset