Power Automate Tutorial - Refresh Power BI Dataset

[@waysilentbob6976]

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!

[@You77alesi]

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

[@kmuralikrishna1582]

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

[@venkataramanakorada5621]

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?

[@gfellay]

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!

[@JonJLevesque]

You can definitely create conditions to do all of that!

[@Anonymous-qb7hd]

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...

[@hariniharan3850]

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?

[@DroneEyes]

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

[@caseybolade2366]

He forgot to mention that the Excel was stored in Sharepoint and that's the only way his process was possible. Hope that helps

[@clairechen4472]

Hi Jon, this is great. Any idea if this works for SQL data sources as well?

[@BreakoutBhaskar]

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.

[@AhmedKhodir-novyPro]

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

[@raghunadhamara6243]

So what is the difference between incremental refresh and automate in terms of reference Is this available for all license

[@JonJLevesque]

This is available to refresh at any interval or also based on other systems activity

[@raghunadhamara6243]

As it is a power bi service tool is this available for all license

[@chetanHkhanapure]

Interesting, its encouraging me me to try with Power platform d365 tables

[@GuvnaOnSpotify]

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

[@nandhakumar6480]

Is it possible to refresh the power bi dataset in Power BI Pro license and Power Automate Free license ??

[@JonJLevesque]

Yes, that should indeed be possible

[@nandhakumar6480]

@@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 .

[@Eddyyc]

Hi Jon, is it possible to refresh a specific query or table?

[@shaikmeharaj9463]

It is possible to do refresh database dataset

[@1yyymmmddd]

Good video. Can you show how to do it on an Excel file sitting in a local machine, not sharepoint ?

[@JonJLevesque]

As soon as i get the UI Flow stuff installed, i can do this!

[@chetanHkhanapure]

Hey Join, Just tried with Power platform Dataverse & it works. Thanks for the video and keep posting awesome things

[@JonJLevesque]

Woot woot! So glad to hear

[@saurabhsrivastava8937]

hi, schedule from blank option is not there anymore, can you please tell me if there's another way out? Thanks

[@ellymonlyz]

Works like a charm! Thanks!

[@VagnerKogikoskiJunior]

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!

[@rayanmohammad910]

Hello, Is this worked with data base source??

[@KakaCat99]

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...

[@GiteshBajaj]

It Solved a Big Problem I Faced. Thank You

[@JonJLevesque]

You’re welcome!!

[@tonyz1616]

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.

[@skulz66]

Hi Jon. This is great! thank you so much!

[@parthpandya2183]

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.

[@nancmadi]

Thank you super easy, great tutorial already set up two that were necessary..

[@JonJLevesque]

Love those wins! Thank you for telling me!! :)

[@YingyingLi-l8w]

really helpful

[@JonJLevesque]

So glad you thought so!

[@tomtomtromme3241]

Thanks! This was absolutely to the point, and it saved my day! :)

[@JonJLevesque]

I’m happy to hear it’s still helping years later!

[@bharathv3269]

Hi Jon, the way of explanation is superb,. Can you please make a video to update parameters in power bi dataset using API?

[@JonJLevesque]

I will see what i can do!

[@achiradissanayake3580]

You just saved me brother 🙏

[@JonJLevesque]

Yessss! So glad to hear that!

[@julioalvarado2700]

You've saved my life! Thanks brother

[@JonJLevesque]

You are so very welcome! :)

[@bigger302539]

thank you

[@yagel81]

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!

[@JonJLevesque]

Hey Yagel! Definitely going to make some UI Flow videos soon!

[@yagel81]

@@JonJLevesque waiting for it! Thanks

[@Totolebarb]

I don't see the point as you already have scheduled refresh in Powerbi, trigger refresh only when something happens ?

[@JonJLevesque]

I showed you how it would look once it did refresh, instead of waiting an hour for it to happen.

[@marounsader318]

how can i see the reflect without refreshing the page, as if i want to make this report on screen or something?

[@namastemalaysia5893]

This was informative..thanks

[@paponpatsrichokthanapong3503]

Thank you so much for this awesome content! My work is much easier after watching this!

[@JonJLevesque]

You are so welcome!

[@ps7503]

hello, how to link excel with power bi?

[@mparthur144]

I am new to Power Automate. If PowerBI is connected directly to the live database, Power Automate would be redundant, wouldn't it?

[@JonJLevesque]

Correct, this is for a non streaming dataset.

[@rhishavdask5598]

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.

[@AlvinRyellPrada]

Same thing. It doesn't work for me to. were you able to figure out how to do it?

[@rhishavdask5598]

@@AlvinRyellPrada I installed "on premise data gateway". Now it's auto updating. Working fine.

[@AlvinRyellPrada]

@@rhishavdask5598 how do i reach out to you then? Haha my head is about to explode haha

[@shyamkalaskar5145]

Can it happens automatically.? I just want to refresh my dataset every 1-minute automatically.

[@JonJLevesque]

Yes, trigger schedule, set to 1 minute Action, refresh dataset Just be warned. This will blow through API Calls

[@shyamkalaskar5145]

@@JonJLevesque thanks a lot

[@DataSpinners]

@@shyamkalaskar5145 Not sure that will work as it will use up one of your 8 refreshes per day.

[@eight800]

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!

[@jreyesvega]

I am trying to refresh power bi from a sharepoint list, and this flow do not work.

[@x17aerialconsultancy51]

I made my first successful one from this… 👌👍

[@JonJLevesque]

Yeahhh buddddyyyy!!

[@SandeepSinghVerma-z4h]

how to create real time dashboards in powerbi workspace without any subscription

[@tomaskavicky]

cheers mate, very handy ;)

[@JonJLevesque]

Glad to hear it!

[@harman210108]

Really helpful!!!

[@yoshihirokawabataify]

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

[@JonJLevesque]

Absolutely agree! I like to show these small ways to make life easier!

[@mtamitolanga]

NIce 1 thank you

[@JonJLevesque]

+Thamsanqa Langa you’re very welcome!

[@luuminhvuong]

Can I use this to refresh report BI which has data source from a sharepoint list?

[@ratneshpandit5084]

yes you can

[@beerhekje9572]

Nice video, unfortunately it is outdated at the moment. There are all new features and different options.