cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

Experts,

 

I need help in placing the 'Delay' to refresh my Power BI dataset after an hour. i.e., after the first refresh. In which step should I place it?

A B
Step 1: Use 'When a new email arrives' action. Step 1: Use 'When a new email arrives' action.
Step 2: Delay (for 1 hour)ORStep 2: Refresh a dataset
Step 3: Refresh a dataset 

Step 3: Delay (for 1 hour)

 

Thanks for your help!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

Hi @BBIUser 

 

Here it is. I will check the value immediately and make sure whether I want to wait or not?

 

Step 1: 'When a new email arrives'

Step 2: Condition Value: Tigger Body        Contains         "Body text" (Example: Report Name has failed to refresh.)

            Yes > Delay (for 1 hour)

            Refresh a dataset

             No > Exit

 

Thanks

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

10 REPLIES 10
Highlighted
Super User III
Super User III

Re: In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

Hi @BBIUser 

 

Not sure what you trying to achieve here. Option B is my choice as it will refresh the dataset first and delay for an hour. What happens if no emails arrived for an hour or two. So there will be further delay after your one hour delay.

 

Thanks 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Community Support
Community Support

Re: In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

Hi @BBIUser,

 

If you want to refresh the PowerBi dataset after 1 hour, the delay action should be in front of refresh action. So it should be Plan A.

Cause you said after the first refresh, I guess you want to refresh the PowerBi dataset twice and get a difference between the two refreshes.

The Plan should be:

A
Step 1: Use 'When a new email arrives' action.
Step 2: Refresh a dataset
Step 3: Delay (for 1 hour)
Step 4: Refresh a dataset

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Frequent Visitor

Re: In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

@v-litu-msft and @abm Thanks for your reply.

 

My apologizes, I should have mentioned this when I posted. I have schedule refreshes setup for all the datasets which will be my first refresh.

With this flow, I am avoiding to do manual dataset refreshes when there is failed or paused refreshes.

 

So basically, after the original schedule refresh, I am creating the flow which starts from 

Step 1: Use 'When a new email arrives' action.

 There should be a delay for an hour after step 1 and then dataset should refresh.

 

I am guessing this should be my solution. Please correct me if I am wrong?

Step 1: Use 'When a new email arrives' action.

Step 2: Delay (for 1 hour)

Step 3: Refresh a dataset

Highlighted
Super User III
Super User III

Re: In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

Hi @BBIUser 

 

After your first schedule refresh are you depending on email trigger to refresh the dataset via flow? Could you explain what this email is used for? Also overall process what you trying to achieve here.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Frequent Visitor

Re: In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

@abm That is correct! I am depending on email trigger to refresh the dataset via flow.

 

Email will have the following:

To - My email address

From - Microsoft Power BI <no-reply-powerbi@microsoft.com>

Subject Filter - Refresh Failed

(or Paused - For this subject filter changes which is "Your scheduled refresh has been paused.")

Highlighted
Super User III
Super User III

Re: In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

Hi @BBIUser 

 

Thanks for your quick reply. So this is used for whenever there is a failure happens you will receive an email, wait for an hour. I presume during this time this will be fixed in an hour and you want to refresh the dataset via flow? I still don't understand why wait for an hour? Also what will happen to your original scheduled trigger?  Also if you receive more than one email then you have multiple triggers at the same time.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Frequent Visitor

Re: In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

So this is used for whenever there is a failure happens you will receive an email, wait for an hour. I presume during this time this will be fixed in an hour and you want to refresh the dataset via flow?

-- Correct! (and also for paused)

 

I still don't understand why wait for an hour? 

-- Nothing specific. I can set it to even 5 mins. Assuming an hour to troubleshoot and fix it before this time.

 

Also what will happen to your original scheduled trigger?  

-- Most of the schedules are daily or weekly. So it has to wait until next day or 1 week.

 

Also if you receive more than one email then you have multiple triggers at the same time.

-- I agree.

Assume, I have 10 different datasets. I am planning to create 10 flows.

 

I am new to Power Automate so not sure if this the correct approach to design for my use case. Any help is appreciated.

 

I am also trying this new design for the same use case: 

Step 1: 'When a new email arrives'

Step 2: Delay (for 1 hour)

Step 3: Condition

Value: Tigger Body        Contains         "Body text" (Example: Report Name has failed to refresh.)

If Yes --

Refresh a dataset

If No --

 

 

Highlighted
Super User III
Super User III

Re: In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

Hi @BBIUser 

 

Here it is. I will check the value immediately and make sure whether I want to wait or not?

 

Step 1: 'When a new email arrives'

Step 2: Condition Value: Tigger Body        Contains         "Body text" (Example: Report Name has failed to refresh.)

            Yes > Delay (for 1 hour)

            Refresh a dataset

             No > Exit

 

Thanks

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

Highlighted
Frequent Visitor

Re: In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

@abm I did not know about the triggerBody(). Thanks for enlightening me on that.

Couple of questions:

1] No > Exit

-- Is 'Exit' an action that needs be applied? I thought 'If no' can be left empty which means Exit - am i correct?

 

2] Can I create a flow with 2 conditions? (Please see the screenshot) Will that work or is it a good design? 

(This will have 9 flows for 10 datasets)

If this do not work, I will create new flow for the 2nd dataset (like as I said before that 10 datasets will have 10 flows)

 

I have 2 conditions in this flow because the Power BI Workspace has 2 different datasets in 1 Workspace.

So, both the conditions and other steps are same with just has different dataset name.

 

Here is my flow for Paused email trigger. 

12.png

Highlighted
Super User III
Super User III

Re: In which step do I need to use the 'Delay' to make my Power BI dataset refresh after an hour?

Hi @BBIUser 

 

Couple of questions:

 

1] No > Exit

-- Is 'Exit' an action that needs be applied? I thought 'If no' can be left empty which means Exit - am i correct?

 

Yes can be empty or if you want to stop the flow then use terminate action.

 

2] Can I create a flow with 2 conditions? (Please see the screenshot) Will that work or is it a good design? 

(This will have 9 flows for 10 datasets)

If this do not work, I will create new flow for the 2nd dataset (like as I said before that 10 datasets will have 10 flows)

 

I have 2 conditions in this flow because the Power BI Workspace has 2 different datasets in 1 Workspace.

 

Going with two conditions are ok but think about could you pass the dataset name as dynamic. Not sure that is supported in PowerBI action step. If it is that's your best option. Also splitting multiple flows are easy to manage and debug.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

Top Solution Authors
Top Kudoed Authors
Users online (7,180)