I created a text column that converted a datetime column according to the formula below. I placed the field in a card and it displays correctly in Power BI Desktop but when I published it, the card now shows a different time, 16:26:33 instead of the text which is 10:07:53. I even purged the original query and card and saved everything, but the new card still behaves the same. It is the converted text field that is showing because it retains the correct date format. Why is Power BI Pro converting a text column to a time column and changing the value?
Last Refresh = FORMAT( Year(LastRefresh[Date Last Refreshed]), "0000") & "-" & FORMAT(Month(LastRefresh[Date Last Refreshed]), "00") & "-" & FORMAT(Day(LastRefresh[Date Last Refreshed]), "00") & " " & FORMAT(HOUR(LastRefresh[Date Last Refreshed]), "00") & ":" & FORMAT(MINUTE(LastRefresh[Date Last Refreshed]), "00") & ":" & FORMAT(SECOND(LastRefresh[Date Last Refreshed]), "00")