Forum Discussion
Download visuals in local machine
Hi Team,
As the business requested one download button in power bi,
There are 4 visuals as using table chart in Power BI, and the requirement is one single click button can down all 4 visual data in one csv or excel in 4 different tabs as below, also file should be download in user local machine who clicked this button.
I tried with Power BI automate but not fullfilled requirement.
They don't want to use three dots available in each visuals to download data.
Hi Anonymous ,
There isn’t a built-in “one-click export all visuals to separate tabs in a local file” button in Power BI. Exporting data from visuals is typically done per-visual or via Power Automate, and exporting directly to the user’s local machine from a report isn’t supported due to security sandboxing.
Practical options you can propose:
Use Power Automate (flow) with a button in Power BI:
Trigger a flow from a Power BI button.
Flow exports data from each visual (or the underlying datasets) to a single Excel file with multiple tabs, then saves to a location accessible to the user (e.g., OneDrive/SharePoint) or emails the file.
Note: Flow runs on the Power BI service and can’t write directly to the user’s local machine; deliver via OneDrive/Email instead.
If you must stay in Power BI Desktop/Service:Create a button that triggers a Power Automate flow (as above) or use the Power BI export options per visual, and clearly document that exports go to OneDrive/SharePoint or email.
Consider a paginated report with a subscription/export flow if that fits your scenario.
Key limitations to communicate:Direct multi-visual, single-click local download with separate tabs isn’t supported due to security and architecture of Power BI.
Export actions can be automated but typically land in cloud storage or are emailed, not saved directly to the user’s C: drive.Please mark this post as solution if it helps you. Appreciate Kudos.
5 Replies
Hi Anonymous ,
Best fit when you need a single Excel file with multiple tabs is to use Paginated report → Export to Excel
You can follow these steps to get the desired result :
1. Build a paginated report on the same dataset.
• Create 4 tablixes (Order, Sales, Ticket, Shipment).
• Add a page break between tablixes and set “Page name” to the desired sheet name.
2. Add parameters that mirror your Power BI slicers.
3. From Power BI report, add a button → drill-through / URL to the paginated report, passing filters via parameters.
4. Users click once → paginated opens with filters applied → Export to Excel (tabs come through as worksheets).
⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together!🚀 [Explore More]GrowthNatives Hi, It seems as you said it is fit the solution as per requirement.
but I didn't worked in paginated. request you please eloborate more on this and share file as well if possible.
Hi Anonymous ,
There isn’t a built-in “one-click export all visuals to separate tabs in a local file” button in Power BI. Exporting data from visuals is typically done per-visual or via Power Automate, and exporting directly to the user’s local machine from a report isn’t supported due to security sandboxing.
Practical options you can propose:
Use Power Automate (flow) with a button in Power BI:
Trigger a flow from a Power BI button.
Flow exports data from each visual (or the underlying datasets) to a single Excel file with multiple tabs, then saves to a location accessible to the user (e.g., OneDrive/SharePoint) or emails the file.
Note: Flow runs on the Power BI service and can’t write directly to the user’s local machine; deliver via OneDrive/Email instead.
If you must stay in Power BI Desktop/Service:Create a button that triggers a Power Automate flow (as above) or use the Power BI export options per visual, and clearly document that exports go to OneDrive/SharePoint or email.
Consider a paginated report with a subscription/export flow if that fits your scenario.
Key limitations to communicate:Direct multi-visual, single-click local download with separate tabs isn’t supported due to security and architecture of Power BI.
Export actions can be automated but typically land in cloud storage or are emailed, not saved directly to the user’s C: drive.Please mark this post as solution if it helps you. Appreciate Kudos.
Hi Anonymous ,
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.Hi Anonymous ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
