Miles Cole on 16 Jun 2020 04:02:27
the API would return the report and workspace IDs for all reports that use an input dataset ID. All reports would be returned across your power bi tenant (even if you do not own or have access) as long as the report is connected to a dataset you own.
Shared datasets are great but it is a upgrade challenge when you have no idea who is actually using the dataset. If someone sources data from your dataset this should prompt the users with a notification that details such as the report name and usage data will be accessible by the dataset owner.
Ideally I would use this to query for the list of reports which need to be binded to the new version of the dataset when upgrades are made. This would be extremely helping when doing deployments with datasets that use incremental refresh.
Steps:
1. Publish new dataset, allow to refresh
2. use API to get list of reports using old dataset
3. loop through report IDs to bind the reports to the new version of the dataset
4. drop old dataset
5. renamed new dataset to maintain naming convention