Forum Discussion

harrinho's avatar
harrinho
Icon for Helper III rankHelper III
8 years ago

Refresh schedule fail

Hi, any ideas if this is a reported issue or where could I probably check?    
Need Help
harrinho's avatar
harrinho
Icon for Helper III rankHelper III
8 years ago

 

 

add to your query editor (Query Editor, View, Advanced Editor) to remove any dates which will cause this error:

#"Remove inappropriate dates" = Table.TransformColumns(#PREVIOUS_STEP_OR_NO#TABLE_NAME, {"COLUMN_TO_AFFECT", each if _ < #date(1900, 1, 1) then #date(1900, 1, 1) else _}),

 

 

Thanks v-ljerr-msft. Any idea where exactly shosuld I add this? To all of my query tables? 

harrinho's avatar
harrinho
Icon for Helper III rankHelper III
8 years ago

It now seems to fail due to a different reasosn 

 

Any ideas what this could mean, would be much appreciated.