strange date format in table

[whitehatone]

Hi!
I got a column in format 2018-09-30 00:00:00.000000 +02:00     

But how do I format a new column as yyyymmdd from that data?  

I tried to split into three new column and merge but I get a -"This query contains transformations that can't be used for DirectQuery."

Error when I apply changes?  

[v-shex-msft · Accepted solution]

HI @whitehatone,

According to your snapshot, you are faced with date timezone values but they seem not correctly recognized and converted to DateTime values. (You can use this type of value in query edit but the power bi data mode table does not support these types of values)

In addition, it seems like you are working with 'direct query' mode. currently, this mode has been limiting most of the Dax functions used in the calculated column or table.

Perhaps you can change to import mode to enable these edit features or try to use t-sql query to do split and transform operation if the data connector support advanced SQL statements.

Power Query SQL Server connector - Power Query | Microsoft Docs
Regards,

Xiaoxin Sheng

[amitchandak]

@whitehatone , You can not do that in a direct query. What you can do, in Report view, you can click on the column and you will see column tools. In column tools, you can choose a format and try

[whitehatone]

Hi!

I cannot find a way to change format?  

Only in drop down is Text?  

[amitchandak]

@whitehatone , Your date has been detected as text. First try to change Data Type to Date, if that works out, then open format and check