Power Automate Tutorial - Refresh Power BI Dataset
Vložit
- čas přidán 25. 11. 2019
- whats up friends?!
In this weeks video i am showing you how to use Power automate to automatically refresh your Power BI Data set! Power Automate + Power BI is a beautiful set of tools when used together!
To get started with Flow head to flow.microsoft.com
To plug into the Flow Community head to aka.ms/flowcomm
To follow me on Twitter head to / jonjlevesque
To make videos like mine check out my shop: www.amazon.com/shop/jonlevesque
As always, Please LIKE & SUBSCRIBE!
Much Love from ME!
- Jon - Zábava
Just wrote a flow like this 5 hours ago! I stored the source data in a SharePoint document library and fired the Power BI refresh whenever the item in the document library was updated. So simple, so awesome!
Hi Jon. This is great! thank you so much!
Works like a charm! Thanks!
You've saved my life! Thanks brother
You are so very welcome! :)
Thank you super easy, great tutorial already set up two that were necessary..
Love those wins! Thank you for telling me!! :)
Thanks! This was absolutely to the point, and it saved my day! :)
I’m happy to hear it’s still helping years later!
This was informative..thanks
Thank you so much for this awesome content! My work is much easier after watching this!
You are so welcome!
Hey Join, Just tried with Power platform Dataverse & it works. Thanks for the video and keep posting awesome things
Woot woot! So glad to hear
Hi, I loved your video! I super understood! But have you a video explaining how to build it? I'd like to transfer that power automate data to power bi, but I don't know how...
It Solved a Big Problem I Faced.
Thank You
You’re welcome!!
Really helpful!!!
Hi Jon, this is great. Any idea if this works for SQL data sources as well?
Thanks for the video. Is there anywhere within Power BI- I can look to see that Flow has been set up for a refresh on the dataset?
thank you
Hey John, any chances we get a Refresh Dataflow action on Power Automate? If someone relies a lot on Dataflows it is simply not useful to refresh the dataset since the Dataflow is still outdated. Tks for the great video!
really helpful
So glad you thought so!
Interesting,
its encouraging me me to try with Power platform d365 tables
You just saved me brother 🙏
Yessss! So glad to hear that!
Hi, Very nice demo. I have a similar requirement, but when Flow starts, it seems it is triggering all dataset refresh and not waiting for the refresh to complete and hence sequential data set refresh is not working and the email going at the end of flow also do not make any sense as the refresh is just triggered BUT not completed. Is there any way to refresh multiple data sets in a sequence and send an email after completing all the refresh?
but when you do the refresh of the dataset in lets say one minute interval, it allows you only to refresh 8 times if you have pro account, and 48 (this might have been updated, not yet tested) times if you have premium capacity
Hi Jon, is it possible to refresh a specific query or table?
In my case, the flow runs successfully, but it doesn't actually refresh anything in PowerBI. I am using an Excel file on sharepoint as the source data. Does anyone have any idea why that is the case? Parameters are correctly marked as per Jon's instructions
I made my first successful one from this… 👌👍
Yeahhh buddddyyyy!!
nice, thanks. Is there a way to manage a result from Dataset refresh action? So a new Power Automate step can be triggered to notify if Dataset refresh got an error
Hi Jon, the way of explanation is superb,. Can you please make a video to update parameters in power bi dataset using API?
I will see what i can do!
how can i see the reflect without refreshing the page, as if i want to make this report on screen or something?
Hi Jon,
Is the Swag dataset is a streaming dataset ?
I thought the Power BI - Refresh data set feature in Flow only for streaming ?
Thanks in advance.
NIce 1 thank you
+Thamsanqa Langa you’re very welcome!
Hello,
Is this worked with data base source??
Hi John,
This didn't work for my web data source. Is there anything else to be done for web source? It works if I manually refresh data in Power BI desktop.
cheers mate, very handy ;)
Glad to hear it!
It is possible to do refresh database dataset
Really sooper..
Is there any way to create report which reports are throws errors because of user credentials ...?
I would like to display this report in powerapp.
Means assume that a user is created a report , now that user is left from organization.
It will throw credentials error or refresh the report.. so I would like to capture this kind all the reports which is having credentials issues
Next one is is there any way to take full control and publish with another user this kind of reports .?
Please reply
Nice simple demo, 😀 I hope more story when do it by manual , by person , about the productivity , how many time of improve, for talk normal persons, non developers, they need the story , how easy their life, their work, 🤗
Most workers get data as email, create new worksheet from all data, import data to Power BI, and report to manager 🤨🤨🤨, every day, every week, it's hard work
Absolutely agree! I like to show these small ways to make life easier!
hi, schedule from blank option is not there anymore, can you please tell me if there's another way out? Thanks
Hey, I am throwing you an idea for a new video.
Refresh the dataset by using - web UI flow !!!
It's easy and there is no limitation of up to 8 times a day like you presented in the video.
Good luck!
Hey Yagel! Definitely going to make some UI Flow videos soon!
@@JonJLevesque waiting for it! Thanks
Great information. But my data is in cloud and I have created a Power BI report by Import mode. How can I automate the reports? Please help me on this.
hello, how to link excel with power bi?
Hi Jon that was a great content!!!
I tried to do that and I followed the exact steps you mentioned but didn't work .... do you need a gateway in order to work?
Thanks
He forgot to mention that the Excel was stored in Sharepoint and that's the only way his process was possible. Hope that helps
Good video. Can you show how to do it on an Excel file sitting in a local machine, not sharepoint ?
As soon as i get the UI Flow stuff installed, i can do this!
Something went wrong
. Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
The Data source Credentials option is disabled in the dataset's settings.
Help!
Im using an ODBC connection to a 1010data datasource. When I try and do a refresh using a Flow. I get error messages. So, I guess it doesn't know the connection credentials. Not sure what to do.. Im not a techie.. so any assistance...
Good video!
How can I do so that the notification is only sent in case the update has failed?
Because the way you did it, the notification is always sent and we don't know if the dataset has actually been updated.
Thank you!
You can definitely create conditions to do all of that!
I am trying to refresh power bi from a sharepoint list, and this flow do not work.
how to create real time dashboards in powerbi workspace without any subscription
I don't see the point as you already have scheduled refresh in Powerbi, trigger refresh only when something happens ?
I showed you how it would look once it did refresh, instead of waiting an hour for it to happen.
So what is the difference between incremental refresh and automate in terms of reference
Is this available for all license
This is available to refresh at any interval or also based on other systems activity
As it is a power bi service tool is this available for all license
Is it possible to refresh the power bi dataset in
Power BI Pro license and Power Automate Free license ??
Yes, that should indeed be possible
@@JonJLevesque
Hi Thanks for your reply
Is it possible to trigger a mail notification
if dataset refresh or failure .
I can able to fix a flow to refresh the dataset .But if I opened the report in power bi service it is not refresh the visuals .
Can you please connect or make videos for us .Please .
I am new to Power Automate. If PowerBI is connected directly to the live database, Power Automate would be redundant, wouldn't it?
Correct, this is for a non streaming dataset.
Can it happens automatically.? I just want to refresh my dataset every 1-minute automatically.
Yes, trigger schedule, set to 1 minute
Action, refresh dataset
Just be warned. This will blow through API Calls
@@JonJLevesque thanks a lot
@@shyamkalaskar5145 Not sure that will work as it will use up one of your 8 refreshes per day.
i was unable to refresh dataset with Microsoft power automate. i did the same procedure but it is not updating. tried both gateway update and microsoft flow. i'm created a dashboard using both excel and mysql database.
Same thing. It doesn't work for me to. were you able to figure out how to do it?
@@AlvinRyellPrada I installed "on premise data gateway". Now it's auto updating. Working fine.
@@rhishavdask5598 how do i reach out to you then? Haha my head is about to explode haha
Can I use this to refresh report BI which has data source from a sharepoint list?
yes you can
Nice video, unfortunately it is outdated at the moment. There are all new features and different options.