Forum Discussion
Solved
date format in pbi
hi im connecting direct query to ADW, in the database, i have a date field that for some reason, pbi convert it to date time. (for all dates show date + 12:00AM) because im in direct, i cant transf...
The column has not changed data types,. It is just a format. You can change the format on measures and on individual visualisations. Sorry I don't have my direct query instance in front of me to be more specific.
MP_123 Here is the snapshot of options I get in query editor using DirectQuery mode. Are you sure you don't get these options ?
MP_123 as a test, instead of using pbi desktop you can connect straight to adw from power bi service and check that way if it gives same behaviour.
thank you both!!
i understood what the format is... my mistake
and anyway, i think the DirectQuery capabilities is due to the data source too
thanks again