Possible Bug, Change data type from text to DateTime using locale not working on powerbi.com refresh

[Anonymous]

Hello,

We using PowerBi model. On that model when converting a Text value to DateTime using specific locale.

Everything working on PowerBI desktop. But after refresh on PowerBI.com the converting result is an error.

The model culture is en-US and for converting we using fi-fi.

On example, we have replaced the error with a specific date.

#"Duplicated Column" = Table.DuplicateColumn(#"Removed Columns", "Luennat.Luenta-aika", "Luennat.Luenta-aika - Copy"),
#"Changed Type with Locale" = Table.TransformColumnTypes(#"Duplicated Column", {{"Luennat.Luenta-aika - Copy", type datetime}}, "fi-FI"),
#"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type with Locale", {{"Luennat.Luenta-aika - Copy", #datetime(2020, 1, 1, 0, 0, 0)}})

Screenshot from desktop and powerbi.com after model refresh

[v-yuezhe-msft]

@Anonymous,

I test your steps on my side and everything works well.


I use this Power BI Desktop version: 2.66.5376.1681 64-bit (February 2019) and this Power BI Service version: 13.0.8309.200. Could you please share your versions of Power BI Desktop and Power BI Service?

Regards,
Lydia