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 ?

     

     

     

     

     

     

     

     

     

     

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

MattAllingtonankitpatira

 

i know that i can transform a column.. but it disabled in direct query. "The step result in a query that is not supported on a DirectQuery mode" .

and i really checked it a few times, in the DB the data shown in date, and pbi adds the 12:00 AM to all of the data...

 

thanks again.. hope you'll have an idea

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
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 ?