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
Can you explain Option 1 briefly?
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.