09-13-2021 15:11 PM
Welcome to Power BI and Power Automate Real Life Use Case and Scenario Series. You are watching the second 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/CSV using Power Automate? We will learn how we can export data to Excel/CSV from Power BI Button.
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 CSV/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
2. Export to CSV 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 or CSV using Power Automate
8. Microsoft Flow to export data from Power BI to Excel/CSV
Chapters:
00:00 Start
01:43 Business Scenario and End Outcome
02:35 Visit Earlier Video - Link in Description
02:54 Add Power Automate Visual in Power BI
03:23 Export Data to Excel/CSV using Power Automate
04:32 Create Array from Power BI DS
06:42 Store Exported file to OneDrive Location
08:40 Send Exported File in an Email
10:31 change Text
11:08 Test Flow
Reference:
Part 1 : Power Automate Visual in Power BI
https://youtu.be/JIjCDo1qY6o
Follow me on Instagram:
https://www.instagram.com/powerplatformguy/
Follow me on all social Media Handles:
https://linktr.ee/dhruvin.shah
#PowerBI #PowerAutomate #Excel #CSV #ExporttoEXcel #PowerPlatform #DhruvinShah #DigitalDhruvin
watch?v=yqbg-6Yo44Y
Awesome, information post. I created a button to export into CSV and email the attachment per your instruction. I did encounter a limitation of 1000 rows per the extract. Power BI limitation is 30,000 rows for CSV and 150,000 for .xlsx as you may already know. Is there a reason why Power Automate is restricting my row count? How I solve this?
Thank you,