Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Date Time Format missing

Submitted by Anonymous on ‎11-22-2019 03:37 AM

I am missing a few Date Time formats in Data View. 

The one that I particulary need is : 'yyyy-MM-dd'. 

I tried by changing Regional Settings(Global and Locale), I reinstalled Power BI( my version: 2.75.5649.801 (19.11)), but still not resolving the issue.

Also I need Data Type:date, not string.

 

What could be the problem in this situation? 

 

Status: New
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎11-24-2019 06:44 PM

Hi @Anonymous, 

 

Based on my test, if the Regional Settings is English(United States) in Power BI desktop version 2.75.5649.801 64-bit (November 2019), it's able to find the date format 'yyyy-MM-dd'. Please change your regional settings for desktop as ours then test again. Also you can try to open the sample report on your side, check if the date format 'yyyy-MM-dd' is available. 

 

q1.PNG

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable
‎11-24-2019 11:16 PM

Hi @v-qiuyu-msft,

As you can see, 'yyyy-MM-dd' still not available for me. My Regional Settings are set to English(United States). What else could I try? 

 

datetimeformatmissing.png

 

Anonymous
Not applicable
‎03-03-2020 06:23 AM

HI all,

I have a similar issue.

I created a report on one computer, with a specific date/time format (d MMM yyy h:mm).

When I opened the report on another computer, with a different regional settings, the date/time field did not display properly (M/d/yy).

When I tried to change the date/time format - I got a cascade of errors ('Something went wrong')

 

Is there another way to define this?

Thanks

Idea Statuses