Automatic exports of Power BI data 🤖 | Run a query against a dataset

On previous videos I showed you how to export data from Power to sharepoint using a button inside a power bi report, but many of you are wondering if it possible to do the export without user's interaction and the answer is YES! Check this video to learn how to do it and I will also show you how to do export it to one drive too.

If you want to learn more about exporting Power Bi data using Power Automate, check the entire playlist:

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:

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

MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10

Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!

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

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

#CURBAL #SUBSCRIBE

[alexrosen]

Very useful tutorial in a time where everything needs to be automated. Thanks!

[prjngl]

awesome work, this helped a lot!

My query was giving me date columns that contain a value such as "2022-11-30T00:00:00"... for no reason as that was never the format. But I see Power BI does this, even with SELECTCOLUMNS. So I ended up just using SELECTCOLUMNS instead like this: SELECTCOLUMNS(_myTable, "Date", FORMAT([Date], "MM/DD/YYYY"))

[Shawn-fybb]

Extremely useful, quick and to the point and solved exactly what I was looking for - thank you

[fredkulas]

Un grand grand MERCI ! Cela faisait 3 jours que je cherchais un moyen pour extraire les données en automatique d'un Power BI ! Super vidéo 🤗🤗👍👍

[antoniogarrido]

Really useful export series, looking forward to next chapters! thanks Ruth!

[akakakakak]

Super fan of Power Automate videos Ruth! Bravo!

[kartickumar]

Thanks for this series !! very easy to understand when you teach !!

[vxmine]

hi Curbal! This was a really helpful video for my use case. Great job as always!

[UcanHdz]

This is exactly what i need, super super thanks to you

[ariadnacasadomena]

HI! Thanks i really needed it. Can you make a video of an automatic export of Power BI Data but adding the data at the end of an existing csv file?

[martyc]

Hi Ruth-- this is just what i needed and i have combined it with your next video to clean up the headers. What i would like to do next is write the date/time into each row in the CSV- can you give me direction on this?

[benhalicki]

Very useful tip for data engineering Ruth, thanks for sharing!

[EugenioLikedit]

Very nice. How do you set up a custom order of columns in - create csv table - step?

[nanatij]

Thanks Ruth! Is it possible to export measures as well? Or only columns?

[DataHacker]

I must have missed run query option in power automate. I was resorting to first creating paginated report and exporting that as csv.
Very neat. It will make my life so much easier!
By the way, you may not need create csv table step. At least when I was expoting paginated report, I could use it as content in the create output file step.

[ErikaG-sh]

Informative video Ruth! Thank you. Quick question, do you know how to change the name of the column headers so that they don't have the table name?

[ayobamiologun]

Great video as always... I can barely keep up with your pace of releasing videos for people's learning.
Please, do yo have any similar video to this one that demonstrates how to run Oracle SQL Query against existing Power BI table columns data (i.e. using the columns as inputs in your SELECT statement), and then do Automatic exports as demonstrated in this video?

[sanprasa]

Hi Ruth, very useful video exporting data from Bi to Excel, How can we prompt the file to open after export, please let me know. Thanks

[khalidmahmud]

Thank You mam. Is there any way to import these file in power bi from onedrive automatically?

[arunkuruganti]

Is there a default option that would append the csv to an existing csv on a regular basis? Instead of writing a new file or replacing, I would want to append to one csv continually.