cancel
Showing results for 
Search instead for 
Did you mean: 

Allow a field formatted as 2019-08-16T00:00:00 to be viewed as a date

I have date fields in my database in the format 2019-08-16T00:00:00. They appear in my visual as a text. When I try to model them as a date, the visual will not refresh.

 

Feedback Type:
Frown (Error)

Timestamp:
2020-02-17T04:40:57.9418892Z

Local Time:
2020-02-17T15:40:57.9418892+11:00

Session ID:
3329e8b5-062e-4143-886e-ca2a051dd2d5

Release:
December 2019

Product Version:
2.76.5678.782 (19.12) (x64)

OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 528049]

Peak Virtual Memory:
38.3 GB

Private Memory:
475 MB

Peak Working Set:
655 MB

IE Version:
11.973.17763.0

User ID:
cadfa44b-e72b-479e-b1c5-92e25494768a

Workbook Package Info:
1* - en-AU, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\colin\Microsoft\Power BI Desktop Store App\FrownSnapShot2021689358.zip

Model Default Mode:
DirectQuery

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PQ_AIInsightsFunctionBrowser
PBI_realTimeRefresh
PBI_QueryDiagnostics
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_decompositionTree
PBI_themeDialog

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Status: New
Comments
Moderator

Hi @colin_sutton,

 

You can go to Query Editor in Power BI desktop, select the column, change its data type to DateTime then to Date type, apply the change to data model by clicking Apply button. 

 

q2.JPG

 

q3.JPG

 

q4.JPG

 

Best Regards,

Qiuyun Yu

Frequent Visitor

Hi Qiuyun,

That doesn’t work for me: “This query contains transformations that can't be used for DirectQuery.”

- my data is coming from an Oracle Database. I worked around it by reformatting the item in my Oracle SQL query.

 

Regards,

Colin