cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rjhale
Level: Powered On

Power BI Connector - Refresh Dataset

I'm happy to see the new actions associated with the Power BI connector.  I'm trying out the new Refresh Dataset action, and I'm wondering if there is a way to get the refresh dataset action to wait within the Flow until the dataset has finished the refresh? I would like to use this action to refresh a published Excel workbook and then use the newly refreshed data within the Flow. 

 

Simply adding a Delay action isn't ideal as each refresh seems to take a different amount of time regardless of how simple the query is.  Thoughts?

2 REPLIES 2
Dual Super User
Dual Super User

Re: Power BI Connector - Refresh Dataset

John White just published a Blog on that topic today.  Take a look at it and see if it doesn't help

https://whitepages.unlimitedviz.com/2019/10/keep-your-power-bi-sharepoint-reports-current-with-micro...



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
rjhale
Level: Powered On

Re: Power BI Connector - Refresh Dataset

His blog post shows how to kick off the dataset refresh in Power BI, but doesn't specifically address waiting for the dataset to be finished processing before going to the next step in the Flow.  I would like to pause the Flow until the data is refreshed as the rest of the Flow will be dependent on having that dataset refreshed.  

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,594)