Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago
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...
Need Help
  • MattAllington's avatar
    MattAllington
    10 years ago

    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. 

  • ankitpatira's avatar
    ankitpatira
    10 years ago

    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 ?

     

     

     

     

     

     

     

     

     

     

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

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.

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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