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
Sure! Here’s a more detailed breakdown of Option 1: Power Automate to OneLake (filtered data):
Step-by-Step:
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.
Store the File Temporarily
- Save the .csv to a temporary location like:
- Azure Blob Storage
- SharePoint Document Library
- OneDrive for Business
- Save the .csv to a temporary location like:
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.
translation and formatting supported by AI
I'm preferring Power Automate Cloud and Power BI Desktop Reports.
In that case, here’s how you can approach it:
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.
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.
translation and formatting supported by AII want to export data from Pie Charts or Line Charts and save it somewhere in Sharepoint or OneLake.
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 LearnExport 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