Automatic exports of Power BI data to a local folder

preview_player
Показать описание
On previous videos I showed you how to export data from Power to onedrive and sharepoint, but many of you are wondering if it possible to export to a local folder and the answer is YES!! Check this video to learn how to do it.

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
Рекомендации по теме
Комментарии
Автор

Thank you very much! I used your step to generate the query to "export" as csv instead of the typical way.

csmtiltm
Автор

Hi Ruth, thanks for sharing your knowledge?
In this case, is there a premium account needed? Thanks!

emanueledelzoppo
Автор

Hello, I currently have a Visualization (table) within a dashboard in Power BI Service that captures the snapshot of live data each day (via incremental refresh). However, I figured that when I follow your steps, the "Run a query against a dataset" always seem to cause an issue. Is there a way for me to auto-export those incremental refreshed results that are in the dashboard in Power BI Service?

potter
Автор

Can you please advise if this will work for embedded power bi when other users would want to export file to their local ?

AlexBakhteyev
Автор

Hi Ruth, Have a quick question.. Is it possible to get the data from the PBI report which I have only Read access and unable to download the file?

divyarathnakar
Автор

Hi Ruth, you made my life easy... pls do these videos more ...

gouthamkarakavalasa
Автор

Hi Ruth!
Is it possible to automate the transfer of dashboards from Power BI to Power Point? At the same time, not all dashboards should be transferred, but only those that have a certain content. The Power Point file is always the same - no need to create a new one each time. At the moment the problem is that all dashboards can only be exported separately.
I will be very glad to hear your answer!

nikitamastega
Автор

Inside the power BI, I have some App, report, dataset (I don't know the creator of this app). In this App, when I click on 3dots of export data after filter with my expected criteria, It downloads the data into a excel file. Can I download this data with power Automate and save in OneDrive folder?

mmbcampus
Автор

Hi Ruth, how can we set dynamically the RootFolder and the Username instead of hardcoded for endusers ?

Psyresidente
Автор

Hi, I wanted to say I really enjoy your videos and find them helpful. I was wondering if there is a way to change the date format of the file that is made from the power automate flow?

valpal
Автор

Hi Ruth! Awesome stuff. I’m trying to deploy a power bi app for my organisation and want to create an easy way for the users to click a button and export PBI viz to excel. However, with both the methods you suggested (one to export csv to a specific destination in sharepoint and another to create a file in local system) I do not have the flexibility to allow the user to select where they want to export the csv to. Any thoughts on how that could be achieved?

RushiLadani
Автор

Hi, when I run the query. error message "Query (1, 1) The expression specified in the query is not a valid table expression" pops up and I have no clue how to fix it.

waicheongericchan
Автор

It looks like you skipped a step you showed how you created cvs table but then when you look at your screen you have select before the create CSV

TheresaOsborne-qt
Автор

Thanks for your efforts, but when get save the csv file it show that i have one only column that contains all the columns of the dataset, pls give me a solution.

ahmedelamri
Автор

How to export data for multiple users this solution for the developer system??

jitendrasharma
Автор

You are the BEST!!!....Thanks very much!!! keep going!!

gabriellopezgl
Автор

How to automate a PI report (table) which has a slicer with many the filters and export the report from PI to csv? Your videos are excellent!!

lolalola
Автор

Hello! Thank you for the video. I have developed the reports for end users and RLS has been put in place from frontend now if i want to create a similar button for end user to be able to download using a button and file should save in their local system, is it possible?

komalkeshwani
Автор

5:36 Hi. Can the file can be saved in the cloud? Does Automate generates a "temporal" or "virtual" version of the file created, so we can grab it ? or do we always need to save the csv. file somewhere and from there trigger another action? In previous videos you saved the csv. file in SharePoint and OneDrive...now it's on your machine. Thanks

elrevesyelderecho
Автор

Ruth, what do we have on the "select" step that suddenly appeared?

thiagofraletti