Change time format (Direct Query)

[stibra]

Hi,

I have the following data as shown in the attached photo:

As can be seen format of creation date is DD.MM.YYYY HH.MM.SS . I would like to change it to DD.MM.YYYY, but cannot use FORMAT with direct queries (Add Column).

Is there another ay of doing this in PowerBI or does it need to be changed on the SQL side?

br

Stian

[v-jiascu-msft]

Hi @stibra,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[v-jiascu-msft · Accepted solution]

Hi Stian,

You can change it in the Modeling menu in the ribbon.

Best Regards,

Dale

[ajnewbs1409]

The menu options shown here are not available for Direct Query columns - is there another way of formating a date field from a Direct Query.