Showing results for 
Search instead for 
Did you mean: 

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



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 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)}})



ScreenShotFromDesktop.pngScreenshot from desktop and after model refresh

Status: Needs Info


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?


Status changed to: Needs Info