Power Bi Date Ouput in Table

[nf7j89x]

Hi Everyone!

I need some help.. I am currently pushing Alteryx data to the PowerBi out put tool. One of the columns is a date. When it is published to PowerBi the date turns into a Date/Time format (please see below). I do not want the time in the columns as it is irrelevant to the data. I have tried a few different formulas to get the time to disappear but nothing seems to work!

The current formula I tried is Left([LineDownDate],Length([LineDownDate])-12).

Any thoughts?

[messi007]

@nf7j89x,

Looks like the problem is in power BI not in Alteryx.

Please change the format to date not date/time in power BI :

Hope this helps !

Regards,

[nf7j89x]

hi @messi007

I try to update the column in PowerBi but it will not let me. The Column tools are blurred when I try to update the field. 

[messi007]

@nf7j89x,

Have you tried with transform data and change the data type from there ?

Chose the column and change the type : 

Hope this helps !

Regards