Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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