Forum Discussion
Export Summarized Data on button
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
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.
translation and formatting supported by AI
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.
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 AICan you explain Option 1 briefly?
