Forum Discussion
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...
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.
Check the data type for that column in your query. I suspect it currently says "Any". Change it to Time and reload the query.
Anonymous, thank you for the reply.
Yes, I checked it, and its type is "Time"