Date format in Power BI desktop doesn't match Power BI app

[artlemaks]

Hi,

I am facing a weird issue where the date format in my Power BI Desktop doesn't match the date format in Power BI app after the report is published. In Power BI desktop, I have it set to dd/mm/yyyy but after it has been published, it reverts back to mm/dd/yyyy. 

What would be the reason for that? All I am doing is selecting the field that has been used for the slicer, going to "Column Tools", then changing Data Type to "Date" and Format to "dd/mm/yyyy". Is there any other way of setting that? 

Thank you for any help. 

[Anonymous]

Hi @artlemaks 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Rico Zhou

[FrankAT]

Hi @artlemaks 

you can do it in model view ( see figure) like this:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[artlemaks]

Hi @FrankAT ,

I have checked your suggestion and the custom format is set to dd/mm/yyyy in model view, as explained by you. But still, when it's published, it appears as mm/dd/yyyy on Power BI App 

[Anonymous]

Hi @artlemaks 

I had a test that shows dd/mm/yyyy in desktop and publish it on Power Service, it shows correctly in dd/mm/yyyy format. I set my Power BI service's language in English and my Data is stored in US. Please check language in your Power BI Service and where is your data stored.

I found an issue like yours and I hope it could help you solve your problem.

Issue: data format difference between service and desktop version

Best Regards,

Rico Zhou

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

[artlemaks]

Hi @Anonymous ,

Thank you for your post. As suggested, I have checked the settings that you have mentioned. The language in my Power BI Service was set to Default, I changed it to "English" but that didn't affect the Service reports. However, when I added ?language=en-GB to the URL, it worked! 

Now my problem is, how and/or where do I add "?language=en-GB" when embedding the reports in my PHP application? 

Regards,

Artur

[Anonymous]

Hi @artlemaks 

I think you may try to add this code (?language=en-GB) to the end of your embedding report's URL.

And check the result in your PHP application.

Did you use Publish to web function to get the Url?

Best Regards,

Rico Zhou

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