Amend Date Format in Live Connection to Remove Time Value

[Anonymous]

Hi,

I'm using Alteryx to publish a dataset to the Power BI Service, which I'm then linking to in Power BI Desktop. When I do this I don't have the ability to amend the format of a field using the Modelling tab or in Power Query.

One of the fields I have coming in from Alteryx is a Date field. When it appears in Power BI it doesn't have the calendar symbol next to it to signify it's a date field. But it also comes in a format that I don't want - it has a Time value of "12:00:00 AM" at the end.

Can you tell me how I can remove this so I only have the date I want?

Thanks,

[adam12asu]

For those who also expereince this behavior I was proveded the below date to create a measure to propery format the date as requested from v-alq-msft,

reportdateMeasure = var _currentdate = MAX('Table'[report_date]) return MONTH(_currentdate)&"/"&DAY(_currentdate)&"/"&YEAR(_currentdate)

[LivioLanzo · Accepted solution]

@Anonymous

you need to make these changes with Alteryx when loading the data to the service. When you connect live you do not have the ability to makes changes tot the model 

[adam12asu]

Its not limited to that tool. Using Powershell I have the date & time formated to just show the date, however, the time of 12:00am is still coming through.  Once the date gets published to a csv or PowerBI a time stamp of 00:00 or 12:00am gets added.