Using Button To Export Data From Table

[santosh1979]

Hello Expert,

Good Day!!

I have created Table in my report where we know by default we have three dots option to export data but in my project end users request to have button on top of Table where can we have option to export data, so dear expert please suggest if we could achieve by using button.

Thanks in advance

Santosh

[v-kpoloju-msft]

Hi @santosh1979,

Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to @burakkaragoz, @bhanu_gautam, for those valuable insights on this thread. Here I mentioned few workarounds that might be resolve the issue. Please have a look into it.

Power BI does not natively support exporting data from a visual using a custom button (like a "Download" or "Export" button placed above the visual). The built-in export functionality is limited to the ellipsis (...) menu or exporting the entire report/page via Power BI Service (e.g., as PDF/PPT).

Add a Custom “Export Data” Button with Tooltip: You can add a dummy button labelled “Export Data” and configure a tooltip to guide users to use the ellipsis menu to export the table data. This offers a more intuitive experience for your end users.

Use Power Automate (Premium/Pro Users): If you are using Power BI Service, you can add a Power Automate visual that lets users trigger a flow to export the table’s data to destinations like Excel, OneDrive, or SharePoint.
Learn more: Create a Power Automate visual for Power BI - Power BI | Microsoft Learn

Paginated Reports (Advanced): For more robust export capabilities like exporting formatted tables with a button you may consider using Power BI Paginated Reports, which support advanced export scenarios to Excel, PDF, etc.
Learn more: What are paginated reports in Power BI? - Power BI | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[burakkaragoz]

Hi @santosh1979 ,

Totally get the request — a lot of users prefer a clean export button instead of using the three-dot menu.

Here’s what you can do:

Option 1: Use a Power Automate button

• Add a Power Automate visual to your report
• Create a flow that exports the data from your table to Excel or OneDrive
• Trigger that flow using the button

This gives you a proper export experience, but it does require a bit of setup and a Power Automate license.

Option 2: Use a bookmark + tooltip trick (visual only)

If you just want to simulate the look of a button:

• Create a shape or button above your table
• Add a tooltip or note that says “Use the three dots to export”
• It won’t export directly, but it guides users clearly

Option 3: Export from Excel connected to dataset

If your users are okay with Excel:

• They can connect to the dataset from Excel (Data > Get Data > Power BI)
• Then filter and export as needed

Unfortunately, Power BI doesn’t currently support native export via custom buttons — but the Power Automate route is your best bet if you want a real export action.

Let me know if you want help setting up the flow — happy to walk you through it.

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.

---

This response was supported by AI for translation and text editing.

[bhanu_gautam]

@santosh1979 , This can be done through Power Automate

use below link to check

https://www.youtube.com/watch?v=BnTipbooeP0