Forum Discussion
Check "Export to Excel" settings via API
Hi IMett ,
Please review the content in the following links by using Powershell and check whether they are what you want.
Exporting all your Power BI reports at once
PowerShell REST APIs - getting list of all reports in the tenant
Get a list of all reports and dashboards in my organization
Get-PowerBIReport -Scope OrganizationBest Regards
Hi Anonymous , thank you for your reply.
Unfortunately that doesn't solve the problem. The task is not to export a specific report (or visual) but to check, whether there are reports in the whole tenant, which allow export of underlying data because of its settings.
Of course there is the possibility to check (and change) this behaviour in the Power BI Desktop or Power BI Service for a specific report - but from an admin perspective, i definitly don't want to check that for a few hundred reports every day 😉 - not to mention that I don't have the permission to access them directly.
So I assume there is no possibility. Does it make sense to open an idea for this topic?
Hi IMett ,
I am also trying to monitor export settings per report in my organisation. I was able to find a Fabric API endpoint that extract the tenant settings and there you can see if reports is enabled for specific security groups (Tenants - List Tenant Settings - REST API (Admin) | Microsoft Learn). However, I am also still looking for an endpoint that extracts report settings. Please let me know if you have found a solution for this problem!