Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
YoanD
New Member

Power BI web wrong date format displayed

Hi, 

I work with the Web application of Power BI, and i get my datas from Streaming API.

In the json body, i have some String values and a Date Value.

When i create a report based on my streaming data (passed or failled test for each date for exemple ), the date is displayed with the wrong format.

 

 send that for exemple :

{
        "failed_test":  15,
        "passed_test":  92,
        "date":  "2023-05-17T12:32:39"
}
 
When it's displayed, i have 05-17-2023 12:32:39,
but what i want is a format dd-MM-yyyy hh:mm:ss  -> 17-05-2023 12:32:39
YoanD_0-1684326458173.png

Is there a solution on the web to format the date ?
I tried to set the language but it did nothing.

My location is in france for information, and it's set in the browser and Power BI to French.

 

Thanks a lot in advance for your help.

5 REPLIES 5
v-xinruzhu-msft
Community Support
Community Support

Hi @YoanD 

You can try to use format() function to set the format of the date in Power BI Desktop. 

e.g Measure = FORMAT(TODAY(),"dd-MM-yyyy hh:mm:ss")

You can also refer to the following link.

Solved: Date displayed in american format - Microsoft Power BI Community

Solved: Help to Change Date Format on Power Bi Service - Microsoft Power BI Community

 

Best Regards!

Yolo Zhu

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

 

 

 

 

Hi, 
Thanks for yor answer.
But like i said, i'm working a the Web version of power BI.

Is it possible to switch between the differente solution of PowerBi to modify date format ? 

And it seems i can't do anything on the desktop version with my streaming data : 

YoanD_0-1684482119919.png

All is lock 

Hi @YoanD 

Set the language of displaying Power BI to French, it can work

vxinruzhumsft_0-1684483060915.png

 

Select 'General'

vxinruzhumsft_1-1684483095933.png

 

Then set the language

vxinruzhumsft_2-1684483120840.png

 

and then refresh your report.

 

Best Regards!

Yolo Zhu

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

 

I already did those manipulation.
My language is set to browser language, and my browser language is set to french, but it doesn't works
I tried to set language to french in powerBi, and in my browser, too but it doesn't works.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.