Date format changing from desktop to online publishing.

[Anonymous]

Hello everyone,

I have a date column in dd/mm/yyyy created in power query. (cells examples : 01/09/2022 and 24/03/2019)

Once I publish the report some dates become mm/dd/yyyy and some don't. (examples become 09/01/2022 and 24/03/2019 like if the 24 cannot be seen as a month so it remains as in desktop). I don't want any switch between dd and mm.

Thank you for your help !

PS : the region I chose is France

[v-junyant-msft]

Hi @Anonymous ,

In Power BI, the date is displayed in relation to the region you select, whether it's in Desktop or Service. As you said, if the region you selected in France, you'll need to adjust both the date type in Power BI Desktop and the language of the browser used by Power BI Service to French.

In the Desktop, you can change the date type here: choose 'transform data', right-click the data column of the type you want to change, choose 'Using Locale'.

And when you use Power BI Service, you need to change the language of the browser used in 'setting':

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello,

I did exactly what you explained : date type using "locale" in Query, Desktop and browser languages as french. Nothing changed. Maybe one clue for you : if I publish the report in my own workspace it is all good. The problem occurs when it's on a shared workspace of the company.
Thank you for your time...

Best regards,

Matteo

[Anonymous]

Hi,

Thank you for your response. But is there another way to do it out of power Query ? In facts I have differents data types in this same column. Otherwise I tried as a test on a sample column and it did work, congrats !

Regards,

Matteo

[v-junyant-msft]

Hi @Anonymous ,

Because you have different data types in your columns, I can't help you modify the date format by Power Query. Can you provide some sample data that tells me what data types are included in the column? I can give it a try for you and see if I can figure out another solution.

Best Regards,

Dino Tao