Forum Discussion
Export Summarized Data on button
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?
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
20 Replies
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-dataIf 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.
translation and formatting supported by AIHi 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.
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.
translation and formatting supported by AI
