Currently, there are multiple workspaces and it is difficult to track if a new Power BI report went live/got published in the list of workspaces to keep the Report Catalog up-to-date.
Report Catalog is an Excel-based file in SharePoint which contains the list of workspaces and report names.
Is there any automated way that can help us get an email notification if a new Power BI report gets published in the list of workspaces, which is not in the excel file?
This was the flow I was planning to build -
SharePoint Excel Report Catalog
↓
Scheduled Automation
↓
Get Reports from specified Power BI Workspaces
↓
Compare with Report Catalog
↓
If report not found in catalog
↓
Send Email Notification
However, I am not able to do this because of below reason-
Access to api.powerbi.com was denied