Changing all dates to UK settings

Power BI
1

I’m in the US and all the dates in the data model are in US format. I published a template app that a UK customer is using. I created a report, using the template app, and published the report to a workspace they have access to. But they are seeing the dates in US format instead of UK. How can I change all of the dates in the data model at once to UK format?

My file is connected to a live template app so when I go to file, options and settings, Options, current file-Regional settings, It gives me a message “Regional settings aren’t available becasue this file uses a live connection to another model.”

2

Hi,
Maybe in Power Query Editor
Change Type → Using Locale

image
image536×510 16.1 KB

and then choose Locale you need:

image
image704×359 9.27 KB

Hope it helps.

Kind regards,
Maja

1 Like
3

Thanks for you help with this @mspanic!

Hi @Usates, this topic has also been discussed in this forum post:

Date timezone changing between Query Editor and Desktop

Please check if the solution can be applied in your query. Thanks!

1 Like