Forum Discussion

mailwin33's avatar
mailwin33
Frequent Visitor
9 years ago
Solved

Time format in BI Online

Hi, everyone! I have some issue with time format data. I have a table in SQL Data Warehouse and connect to it with "Get Data" button in BI Online. There is a column "registration" in the table wit...
Need Help
  • ankitpatira's avatar
    ankitpatira
    9 years ago

    mailwin33 PBI online doesn't give you any data modelling capabilities atm and so you cannot force it to change column's data type (although it should recognise the type as Time by default) so your only option atm is to use PBI desktop for column type change to date/time and then publish to PBI service.

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

mailwin33 PBI online doesn't give you any data modelling capabilities atm and so you cannot force it to change column's data type (although it should recognise the type as Time by default) so your only option atm is to use PBI desktop for column type change to date/time and then publish to PBI service.

mailwin33's avatar
mailwin33
Frequent Visitor
9 years ago

ankitpatira, thank you for the advice.

I made exactly that thing and now it's all right.

And it is very interesting why PBI Online recognize it as Date rather than Time.

Thank you for the help.