#date keyword stop working properly in Dataflow the 13th January 2021

[danicost]

I have a Dataflow that refresh eveyday since more than a year now without issues up to the 13th January 2021.

That day something happened in the Dataflow service becase the keyword #date was changed to the string #"#date".

That change was done by the service, and now it is not possible to changing back to the original keyword #date.

I have solved the issue combining the functions Date.FromText and Text.From, ie. changing #date([Year], [Month], 1) to Date.FromText(Text.From([Year])&", "&Text.From([Month]&",  1").

My concern is that this kind of issues, which are not the first time that happened, will produce wrong data for my organization.

I mean changes automatically done by the service in the queries.

[v-easonf-msft]

Hi , @danicost 

Sorry, I did not find a relevant solution for this problem on the forum.

If you are a pro user, it is recommended to open a support ticket to seek help from the MSFT Support team .

Best Regards,
Community Support Team _ Eason