Power BI report is not removed after deleting it from the source

Question

On 16/08 I have deleted a Power BI report and all related artefacts (dashboards, dataset, data pipelines) from the Fabric workspace they were hosted. After a full scan on 19/08 on Purview all are still ingested within that workspace.

The only way to remove these was to manually delete them as assets on Purview. After running a new full scan these were not ingested again. This solves my issue at a small scale and within my workspace where I know which reports are depreciated.

My organisation manages around 8k reports (without accounting for all other Power BI artefacts). I cannot delete all of these manually, lose all metadata, do a full scan again and repopulate their records.

Is there an option of Purview to remove PowerBI assets from the data catalogue when they do not exist on the data estate?

Answer 1

Hi @PurviewAdmin
Thank you for the question and using Microsoft Q&A platform.

Based on the information you provided, it seems that the Power BI artifacts were not removed from Microsoft Purview after you deleted them from the Fabric workspace. This can happen if the scan has not been updated after the deletion of the artifacts.

To answer your question, there is no automatic option in Purview to remove Power BI assets from the data catalog when they do not exist on the data estate. However, you can use the Purview REST API to automate the deletion of assets that are no longer present in the data estate.

You can use the Purview REST API to retrieve a list of assets that are present in the data catalog and compare it with the list of assets in the data estate. If an asset is present in the data catalog but not in the data estate, you can use the API to delete the asset from the data catalog.

For more information on how to use REST API to delete the assets please refer to the below link:
https://learn.microsoft.com/en-us/answers/questions/412522/delete-an-asset-in-purview-using-rest-api

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.