Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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.
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.