Forum Discussion

IMett's avatar
IMett
Helper III
4 years ago
Solved

Check "Export to Excel" settings via API

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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