Yearly Schedule Refresh in Power BI Service?

[BBIUser]

Hi,

I am aware that there is no Yearly Refresh Frequency in the Schedule Refresh and there are only Daily and Weekly. But I wanted to know if there are any new ideas or request out there by the community members?

Can I know why the Yearly option was not part of the Refresh Frequency? (Because this seems to be an ideal need, if I am not wrong)

Thanks!

[hugoss]

Hi @BBIUser ,

I've faced this problem and posted here my simple and no-cost solution: https://www.linkedin.com/pulse/power-bi-monthlyyearly-update-hugo-silva.

Please, consider mark this as solution if it suits to your problem.

[TomMartens · Accepted solution]

Hey,

basically from my experience it a rare requirement to refresh a data source just once year. For this reason this might be one of the reasons that there is no yearly refresh option.

But maybe you might consider to create a Flow that refreshes your dataset:

• there is this presentation: 

  https://pbig.nl/wp-content/uploads/2019/04/04a%20Ida%20Bergum%20-%20Microsoft%20Flow%20for%20Power%2...

• and there is also a blog around this: https://www.idabergumdata.com/home/microsoft-flow-automation-using-power-bi-api

Regards,

Tom

[BBIUser]

Thanks @TomMartens ! Good to know that there are other options like Flow. I will give a try.