Timestamp format

[learner03]

I have a last refresh timestamp on each report.

For that I am using below query-

let
Source = DateTime.LocalNow(),
#"Converted to Table" = #table(1, {{Source}}),
#"Inserted Date" = Table.AddColumn(#"Converted to Table", "Date", each DateTime.Date([Column1]), type date),
#"Inserted Time" = Table.AddColumn(#"Inserted Date", "Time", each DateTime.Time([Column1]), type time),
#"Renamed Columns" = Table.RenameColumns(#"Inserted Time",{{"Column1", "DateTime"}}),
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "DateTime MyZone", each DateTime.From ( [DateTime] ) + #duration(0, +10,0,0))
in
#"Added Custom"

This shows last refresh time in power Bi service in local time. I use "DateTime MyZone" in a card visual to show the date/time. But in service, it shows the date time as month first  then date (American format) but I nedd Date/month/Year and time.

[amitchandak]

@learner03 , There regional setting at Power BI Desktop or service level that can change the format

refer

https://learn.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions

https://community.fabric.microsoft.com/t5/Desktop/Problem-with-Regional-Settings/m-p/310126