Export Summarized Data on button

[lovishsood1]

Hey everyone,

I'm currently looking for a way to export data based on Filters put on the Power BI Report.

Is there any way to export the dataset after applying filters/slicers on the POWER BI REPORT?

I'm aware of this part where we can export data of a visual by clicking on three dots but I'm not looking for that.

This is for the client :
Requirement: If the user puts any slicers, then I need to add a button that can export Summarized/Filtered Data, which I need to send to either some Database(One Lake or any other) for other analysis.

Button can be outside the report inside a portal where Report is embedded or Internal inside the Power BI Report.

Please suggest some solutions. If this is not achievable, can I get the Microsoft Doc where this is listed as a limitation?

[burakkaragoz]

Hi @lovishsood1 ,

Power BI doesn’t support exporting filtered data directly to a database with a button. But here are some workarounds:

• Use Power Automate to create a button that sends filtered data to OneLake or another destination.
• If the report is embedded, you can use the Power BI JavaScript API to read slicer values and export the data.
• You can also use Paginated Reports to export filtered data, but that requires Report Builder.

This is a known limitation. You can check the official docs here:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-export-data

---

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[lovishsood1]

Hi @burakkaragoz 

1. Could you please share the process to send filtered data to OneLake using Power Automate. I cannot find direct plugin/connector inside Power Automate.

2. Please share this as well using Javascript API

Above mentioned link is not working. 404 Error is coming.

[burakkaragoz]

Hey @lovishsood1 

Thanks for pointing that out – looks like the link broke, my bad!

Here’s a quick breakdown for both approaches:

1. Power Automate to OneLake (filtered data)

There’s no direct OneLake connector yet, but you can work around it by:

• Exporting the filtered data to a CSV using Power BI paginated report or Power Automate Desktop.
• Then use Azure Blob Storage or SharePoint as an intermediate step.
• From there, you can move the file into OneLake using a Dataflow Gen2 or Notebook inside Fabric.

Let me know what kind of data you’re working with – I can tailor the steps better.

2. JavaScript API

You can use the Power BI JS API to:

• Capture the filtered data context using getFilters() or getData() (if embedded).
• Then send that data to a backend service (e.g., Azure Function or API endpoint).
• From there, push it to OneLake via REST or Fabric pipeline.

If you want, I can share a sample script for the JS part too.

---

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[lovishsood1]

Can you explain Option 1 briefly?

[burakkaragoz]

Sure! Here’s a more detailed breakdown of Option 1: Power Automate to OneLake (filtered data):

Step-by-Step:

1. Export Filtered Data

   • Use Power BI Paginated Report or Power Automate Desktop to export the filtered data from your report to a .csv file.
   • If you're using Power Automate Desktop, you can simulate the export by reading the visual data and writing it to a file.

2. Store the File Temporarily

   • Save the .csv to a temporary location like:
     • Azure Blob Storage
     • SharePoint Document Library
     • OneDrive for Business

3. Move to OneLake

   • Use a Dataflow Gen2 or a Notebook in Fabric to pick up the file from the temporary location and write it into your OneLake Lakehouse.
   • In a Notebook, you can use pandas or PySpark to read the file and write it to a table or folder in your Lakehouse.

---

Let me know which tools you’re using (Power Automate Cloud/Desktop, Paginated Reports, etc.) and I can tailor the steps even more.

[lovishsood1]

I'm preferring Power Automate Cloud and Power BI Desktop Reports.

[burakkaragoz]

In that case, here’s how you can approach it:

1. Export filtered data from Power BI Desktop

   • Use a Paginated Report if you want precise control over the export. You can publish it to the service and trigger it via Power Automate Cloud.

2. Power Automate Cloud flow

   • Use the Power BI action to trigger the paginated report export.
   • Save the output to OneDrive, SharePoint, or Blob Storage.
   • From there, use a Notebook or Dataflow Gen2 in Fabric to move the file into OneLake.

Let me know if you want help setting up the flow or the paginated report part. I can walk you through it.

[lovishsood1]

I want to export data from Pie Charts or Line Charts and save it somewhere in Sharepoint or OneLake.

[v-bmanikante]

Hi @lovishsood1 ,

Thank you for reaching out to Microsoft Fabric Community Forum.

@burakkaragoz Thank you for your quick inputs.

To export filtered data from Pie Charts or Line Charts and save it to SharePoint or OneLake, you can use the following approaches:

  Paginated Reports with Power Automate Cloud:

• Recreate the chart’s data in a Paginated Report (using parameters to reflect slicers).Publish it to Power BI Service and then use Power Automate to export the report and save it to SharePoint or Blob Storage.

Then, move it to OneLake using a Notebook or Dataflow Gen2.

 Power BI Embedded + JavaScript (possible in some cases):

• Use the Power BI JavaScript API to extract filtered visual data (e.g., from Pie/Line chart).
• Send it to a backend or Power Automate Flow.
• Save the data to SharePoint, then transfer to OneLake.

Please note that, Power BI can’t export visual data (like Pie/Line charts) directly using Power Automate unless it's set up through Paginated Reports or Embedded scenarios.

 Please refer the below documents:
Export Power BI embedded analytics reports API - Power BI | Microsoft Learn

Export data from a Power BI visualization - Power BI | Microsoft Learn

Reports - Export Report - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Power BI - Connectors | Microsoft Learn

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[lovishsood1]

Hi @v-bmanikante ,

Could you please provide me with the documentation of Power BI Embedded and what are options to export if I embed my report on customer's website?

I also want to know the list of functions I can use to export data using APIs.

I have this doc : https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-customer-app

but this does not give any further info on export functions lists or what the capabilities of embedding a POWER BI Report for Customers.

I hope I'm able to make you understand what do I need exactly!!

[v-bmanikante]

Hello @lovishsood1 ,

 Export Options in Power BI Embedded:

Method	API Type	Usage	Output Format
exportData()	JavaScript SDK	Export data from a single visual	CSV (Summarized / Underlying)
ExportToFile	REST API	Export full report/pages	PDF, PPTX, PNG
ExportPaginatedReport	REST API	Export tabular data via paginated report	Excel, PDF

Supporting Functions

Function	API Type	Purpose
getPages()	JavaScript SDK	Retrieve pages in a report
getVisuals()	JavaScript SDK	Get visuals on a page
getFilters() / setFilters()	JavaScript SDK	Read/apply filters for drillthrough/export
GetExportToFileStatus	REST API	Track status of export jobs

Please refer the below documents:

• Embed content in your Power BI embedded analytics application - Power BI | Microsoft Learn
• Power BI JavaScript API Overview
• Export Report using REST API
• Embedding Power BI for Customers
• Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @lovishsood1 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Please don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[lovishsood1]

Hi @v-bmanikante ,

I'm currently looking into it. getVisuals() is currently not working on my end. It is returning "no visual found".

 Though I have added 3 visuals;

I do not know why it is returning "No Visual Found"!!!

P.S. : I'm trying to explore Power Automate as well ,as you cAN see from Export Data Button.

[v-bmanikante]

Hello @lovishsood1 ,

Thank you for the follow-up, and sorry to hear that you're still experiencing the issue.

Kindly review the screenshot provided below, as it offers additional context for the issue. Additionally, please refer to the attached link, which outlines similar issues that may be relevant.

Solved: Export embedded report with filters - Microsoft Fabric Community

Solved: Exporting the data with filters applied. - Microsoft Fabric Community

Solved: Export Data from Power BI embedded - Microsoft Fabric Community

Export data from a Power BI visualization - Power BI | Microsoft Learn

Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @lovishsood1 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Please don't forget to give a "Kudos " – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @lovishsood1 ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Please don't forget to give a "Kudos " – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[lovishsood1]

Hi @v-bmanikante ,

No, I'm still stuck at exporting data. 

https://github.com/Microsoft/PowerBI-Developer-Samples

I used the above sample code and tried embedding my report. Embedding is successful but not able to trigger the export data functionality. 

I also tried triggering Power Automate Flow from the code using the HTTP method

THis flow is not getting triggered as well.

[v-bmanikante · Accepted solution]

 Hello @lovishsood1 ,

Thank you for the follow up.

Since this appears to be a platform level or configuration issue beyond what we can resolve locally, I recommend raising a support ticket with Microsoft Power BI Support.

When opening the ticket, it will help to include a description of the issue, steps you have taken so far and the embed configuration and environment details (like report ID, workspace, authentication method) etc.The support team can investigate further on the backend and provide more targeted help for your specific environment.

https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @lovishsood1 ,

Just checking, have you had a chance to open a support ticket, as suggested. Was the issue resolved ?if so, it would be great if you could share the solution here as well and please consider marking it as the accepted solution to help others as well.

Warm regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @lovishsood1 ,

As we haven’t heard back from you, we will go ahead and close this ticket for now.

If you need any further assistance, please don’t hesitate to raise a new ticket, we are always happy to help. Thank you for reaching out to Microsoft Fabric Community Forum.

Our sincere apologies if there was any inconvenience caused.

Regards,

B Manikanteswara Reddy