Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
However, when i try to schedule a refresh i get error that i need to run the refresh atleast once?
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
Solved! Go to Solution.
Hi @THEG72 ,
Please add a refresh time for your data flow here.
Hi @THEG72 ,
Please add a refresh time for your data flow here.