How to Export filtered data to Excel from Power BI button using Power Automate?

Welcome to Power BI and Power Automate Real Life Use Case and Scenario Series. You are watching the third episode of this series. Sometimes, there is a need where we need to export filtered datasets from Power BI using the button. Then how can we do that? How we can export Filtered Dataset from Power BI to Excel using Power Automate. We will learn how we can export data to Excel from Power BI Button.
In my earlier episode, I explained, how to export data in CSV format. But I received lots of comments to export the data in an Excel file. Every time, when user clicks on the button, a new Excel file should be generated and it should be sent as an email attachment.

We will use the concept of Power Automate Visual with Power BI. We will pass filter context from Power BI to MS Flow and then Create a Excel file to the OneDrive Location or send the exported data as an Email attachment. Stay tuned throughout the entire video for more information!

Here, you can learn the following concepts:
1. Export to Excel button in Power BI
3. Power Automate and Power BI
4. Power BI and Microsoft Flow
5. How to Export data from Power BI to Excel using a button?
6. How to send Exported data in Email from Power BI?
7. Export data to Excel using Power Automate
8. Microsoft Flow to export data from Power BI to Excel

Chapters:
00:00 Start
01:15 Overview of Requirements
02:36 Add Power Automate Visual
03:15 Publish the Report
03:44 Add Fields
04:02 Create Flow
04:32 Create Blank Excel Template
13:54 Send Excel as Email Attachment from Power BI
16:55 Summary of Flow
17:42 Test Flow
19:30 Limitations
21:00 Subscribe

Reference:
Part 1: Power Automate Visual in Power BI
   • All you should know about Power Autom...  

Part 2: How to Export filtered data to CSV from Power BI button using Power Automate?
   • How to Export filtered data to CSV fr...  

Part 3: How to Export filtered data to Excel from Power BI button using Power Automate?
   • How to Export filtered data to Excel ...  

Follow me on Instagram:
  / powerplatformguy  

Looking for Consultancy? Connect Here!
https://powerplatformtrainings.com/co...

Follow me on all social Media Handles:
https://linktr.ee/dhruvin.shah


#PowerBI #PowerAutomate #Excel #ExporttoExcel #PowerPlatform #DhruvinShah #DigitalDhruvin