Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.