Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I am trying to refresh my dataset every first day of a month.
Power BI service and Power Automate can only schedule the refresh based on different days (Sun, Mon, etc.) of a week, but the first day of a month is not necessary on extact day.
Does anyone know how to do it?
This issue seems bug many people since 2017 😥
Many thanks!
Solved! Go to Solution.
Thanks Migasuke! It works! Just one more question: can we select to update ALL datasets in the workspace? Now I can only select one dataset one time. Thanks!
Hi,
I don't think you can do ALL, but definitelly you can do several. In your flow you just need to select action for parallel branch. Result would look something like this:
In case you need to refresh ALL datasets in your workspace / tenant - best is to use REST API. It is a bit more advanced since you need to write your own code, but with some youtube channels it is not that difficult.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.