Check "Export to Excel" settings via API

[IMett]

Hi all,

our organization's governance policy is rather strict in respect to exporting data from Power BI Service to Excel.

However since this is an important feature for our end users, we try to enable this feature, however we need to monitor how it is used.
Is there a way to check via REST API or in any other way from an Admin perspective whether a given dataset has
- "export summarized data" enabled (which is usually ok)

- "export underlying data" enabled (which is only ok under special conditions)

I didn't find any API call which delivers this information yet.

[IMett]

Hi @v-yiruan-msft , 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?

[IDDelen]

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!

[v-yiruan-msft · Accepted solution]

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 Organization

Best Regards

[v-yiruan-msft]

Hi @IMett ,

You can use the following REST API to export the specified report from the specified workspace to the requested format file. But this REST API does not return what type of data( summarized data or underlying data) was exported...

Reports - Export To File In Group

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/ExportTo

If you want to see the type of data (summarized data or underlying data) exported from the corresponding report file, you can refer to the documentation below to see it in Power BI Desktop and Power BI Service respectively.

Power BI Desktop: 

1. From the upper left corner, select File > Options and Settings > Options.
2. Under CURRENT FILE, select Report settings

Power BI Desktop

Power BI Service:

1. Navigate to the workspace which the special report located in

2. Find the report and click More icon to select "Seetings"

Power BI Service

Best Regards