Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Marac0105
Frequent Visitor

Refresh Power BI data set on specific list of dates with Power Automate

Hi all,

 

I would kindly ask if someone can help - I have list of specific dates and need to build Power Automate flow to refresh Power BI data set based on this dates list.

List of dates can be stored in SQL, excel on SharePoint or as a SharePoint list.

 

Thank you in advance.

1 ACCEPTED SOLUTION
christinepayton
Super User
Super User

The typical way to do flows like this is to do a scheduled one that runs daily and checks todays date (utcnow()) vs each date in the list (for each loop), with a condition if they are equal to run the rest of the flow. Make sure to convert the dates for both to the same format before comparing (they'll include times by default so never match).

 

Add hours to utcnow() to convert to your time zone first, particularly if you're on the other side of the world from UTC.

 

You can drop the "refresh Power BI dataset" action under the true condition branch.

View solution in original post

1 REPLY 1
christinepayton
Super User
Super User

The typical way to do flows like this is to do a scheduled one that runs daily and checks todays date (utcnow()) vs each date in the list (for each loop), with a condition if they are equal to run the rest of the flow. Make sure to convert the dates for both to the same format before comparing (they'll include times by default so never match).

 

Add hours to utcnow() to convert to your time zone first, particularly if you're on the other side of the world from UTC.

 

You can drop the "refresh Power BI dataset" action under the true condition branch.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.