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

[BBIUser]

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)	OR	Step 2: Refresh a dataset
Step 3: Refresh a dataset		Step 3: Delay (for 1 hour)

Thanks for your help!

[abm]

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 

[v-litu-msft]

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.

[BBIUser]

@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

[abm]

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

[BBIUser]

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

[abm]

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

[BBIUser]

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

[abm · Accepted solution]

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

[BBIUser]

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

[abm]

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