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.