Calendar Data flow wont schedule for refresh but on demand refresh works fine

[THEG72]

Hi Support,

I created a simple power query dataflow for a calendar table. Within Power Query the refresh works fine and no errors are shown in the query.

Any on demand refresh works perfectly and shows in the Refresh history as completed successfully!

On Demand Refresh working

However, when i try to schedule a refresh i get error that i need to run the refresh atleast once?

Schedule Refresh ScreenError Message in top right hand corner

Has anyone else had this problem with a simple calendar M code? i have hard coded start and end dates and used the List.Dates function to populate the table.

Is hardcoding this effecting the refresh or does it need dynamic start and end dates to work correctly?

Thankyou for any help or suggestions!

Here's the m code incase you need it

let
StartDate = #date(2018, 7, 1),
EndDate = #date(2020, 6, 30),
CurrentDate = DateTime.Date(DateTime.FixedLocalNow()),
FiscalYearEndMonth = 6,
DateLists = List.Dates(StartDate, Number.From(EndDate - StartDate)+1, #duration(1,0,0,0)),
ToTable = Table.FromList(DateLists, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
RenameCol = Table.RenameColumns(ToTable, {{"Column1", "Date"}}),
DataType = Table.TransformColumnTypes(RenameCol, {{"Date", type date}})
in
DataType

[v-frfei-msft · Accepted solution]

Hi @THEG72 ,

Please add a refresh time for your data flow here.