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 Can you not click on Edit Queries, go to Query Editor, under Transform tab, change Data Type to Date.