How to create a Export to Excel / CSV button in Power BI

In todays video I will show you how to create and export to excel or CSV button in Power BI!! Take a look!

Chapters:
00:00 Intro
01:30 Export to CSV button
05:15 Apply the flow to the button
05:30 Format the flow button
06:00 Check if the flow run successfully
08:00 Export to excel button
09:30 Pre-requisites for the flow to work
11:15 Check if your flow is successful in Power Bi
13:00 Export only filtered data


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[CurbalEN]

I found a way to export up to 100k rows to Excel, check it here:

[Adam-cdxd]

Thank you so much, that is very helpful! My managers "Can we export that to excel?" will be thrilled to bits!

[scfo]

This feature will be incredible for things like mapping new accounts, projects, employees etc to their different categories. Really great video. This one will get saved in a special folder. Thank you so much.

[praveenkumar_]

Today I have learned something about Power Automate for the first time and I really liked it's flow of execution and well explained Ruth!!😄😊

Now this one is my favorite update this year so far, particularly this export functionality. It's so useful. Great example Ruth, thanks! 😊

[saurabhgadre]

Very awesome update. Last month i was trying to get data but not able to convert it to excel. Thank you for sharing this :)

[AaronElliottKC]

Great explanation! Very simple steps. Thank you so much!

[Reginaldpenguins]

Thanks for this Ruth excellent as always! I'd love to see more of your ideas on what could be done with this new Power Automate functionality

[nrod]

You saved me with this video. Thanks a lot !!!

[RobertoStaltari]

You read my mind! I really need this, Thanks Ruth

[sophiatoh]

Excellent video as always Ruth! Thank you for your videos, they are very helpful in my Power BI learning journey. Looking forward to seeing more videos about Power Automate with Power BI! :)

[Nazman]

Great work, thanks so much... got the PowerBi button to work straight away, your video is so easy to follow !!

[KaushalKishoreDixit]

Ruth, I Love You 😘
This trick saved a lot of my time and firms money. As always you are awesome 😁

[CurbalEN]

If you want to automatically export to excel without user interaction and schedule it, here is the way to do it instead:

[RushiLadani]

Thank you very much! Awesome functionality to have for my self-service report.

[lenzypetty]

Awesome...perfect timing...I just got a request to make it easier for end users to export to excel. Really Really Great Video! So grateful you did this video.

[peterthompson]

Excellent explanation, thank you. I have used Power Automate to export details of the currently selected Power BI item(s) to Microsoft Lists. Subsequently importing the list back into Power BI during the Scheduled Refresh. This means that I can present a list of data to the users, and allow them to mark items as 'Checked off' and refresh the view when the next load of items comes into Power BI. It does require the items to have a unique identifier to ensure things don't get confused, but this is a relatively simple field to create on each table - which is linked back to the imported List. If there is a need to add an explanation, these can be prepopulated in each Power Automate Flow, or more complicated explanations can be entered in Lists by editing the appropriate record (which is a little more work, but completes the user experience).

[elrevesyelderecho]

Love you! Bookmark as a favourite! I will watch it later! Thanks!!!

[eleftheriosioannidis]

Well done Ruth for all you useful videos!
I would love to see how we can create a button that can send the filtered data by e-mail
e.g. Table [Monthly Sales per Employee]
- Filter table by desired Employee
- Send to the selected Employee
Thank you again for all your videos!

[yeraldo]

What an awesome feature!!! That's why I'm also learning Powerapps and Power Automate thus I can improve my skills.

Thanks for the great work, keep it up!!