Export Summarized Data on button

Hello lovishsood1 ,

 Export Options in Power BI Embedded:

Supporting Functions

Please refer the below documents:

• Embed content in your Power BI embedded analytics application - Power BI | Microsoft Learn
• Power BI JavaScript API Overview
• Export Report using REST API
• Embedding Power BI for Customers
• Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Regards,

B Manikanteswara Reddy

Hi lovishsood1 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy

I 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 Learn

Export 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

Regards,

B Manikanteswara Reddy

Hi Anonymous ,

Could you please provide me with the documentation of Power BI Embedded and what are options to export if I embed my report on customer's website?

I also want to know the list of functions I can use to export data using APIs.

I have this doc : https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-customer-app

but this does not give any further info on export functions lists or what the capabilities of embedding a POWER BI Report for Customers.

I hope I'm able to make you understand what do I need exactly!!

Hi Anonymous ,

I'm currently looking into it. getVisuals() is currently not working on my end. It is returning "no visual found".

 Though I have added 3 visuals;

I do not know why it is returning "No Visual Found"!!!

P.S. : I'm trying to explore Power Automate as well ,as you cAN see from Export Data Button.

Hello lovishsood1 ,

Thank you for the follow-up, and sorry to hear that you're still experiencing the issue.

Kindly review the screenshot provided below, as it offers additional context for the issue. Additionally, please refer to the attached link, which outlines similar issues that may be relevant.

Solved: Export embedded report with filters - Microsoft Fabric Community

Solved: Exporting the data with filters applied. - Microsoft Fabric Community

Solved: Export Data from Power BI embedded - Microsoft Fabric Community

Export data from a Power BI visualization - Power BI | Microsoft Learn

Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Regards,

B Manikanteswara Reddy

Hi lovishsood1 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy

Hi lovishsood1 ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

B Manikanteswara Reddy

Hi Anonymous ,

No, I'm still stuck at exporting data. 

https://github.com/Microsoft/PowerBI-Developer-Samples

I used the above sample code and tried embedding my report. Embedding is successful but not able to trigger the export data functionality. 

I also tried triggering Power Automate Flow from the code using the HTTP method

THis flow is not getting triggered as well.

Hi lovishsood1 ,

Just checking, have you had a chance to open a support ticket, as suggested. Was the issue resolved ?if so, it would be great if you could share the solution here as well and please consider marking it as the accepted solution to help others as well.

Warm regards,

B Manikanteswara Reddy

Hi lovishsood1 ,

As we haven’t heard back from you, we will go ahead and close this ticket for now.

If you need any further assistance, please don’t hesitate to raise a new ticket, we are always happy to help. Thank you for reaching out to Microsoft Fabric Community Forum.

Our sincere apologies if there was any inconvenience caused.

Regards,

B Manikanteswara Reddy