The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 Screen
Error 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
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.