topic Export Data from Power BI embedded in Developer

Export Data from Power BI embedded

Ruchita-BOIT — Tue, 27 Jun 2023 13:24:48 GMT

Hi all,

Is there any way in which I can export my report data (filtered data) in excel/csv format from Power BI embedded report? The export is available from desktop and service but not from the embedded report. I also tried Power Automate button. It is also not supported in embedded analytics. The Rest APIs also seem to support only pdf, ppt and png formats.

Each visual data can be exported to Excel. But I want to export the complete report data.

Is there any way to do this? Help would be appreciated.

Regards,

Ruchita

Re: Export Data from Power BI embedded

Anonymous — Thu, 29 Jun 2023 05:44:47 GMT

Hi @Ruchita-BOIT,

Export feature also available on embedded report. You can choose a visual and click on the ellipsis of the visual to select the export data option.

If this feature does not appear on your side, please check the permission and tenant settings to confirm if admin has disabled the export features.

About tenant settings - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

Re: Export Data from Power BI embedded

Ruchita-BOIT — Fri, 30 Jun 2023 06:01:19 GMT

Hi @Xiaoxin sheng,

Thanks for your inputs. But I am interested in exporting the complete filtered report data to excel in one go and not each and every visual. Is there anyway in which I can do it. I was able to achieve that using the Power automate export button. It works for Service but doesnt work on embedded.

Regards

Re: Export Data from Power BI embedded

Anonymous — Mon, 03 Jul 2023 09:02:42 GMT

Hi @Ruchita-BOIT ,

After I check on the documents, it seems not able to directly export data from power bi embedded report.
Regards,
Xiaoxin Sheng