Time format in BI Online

[mailwin33]

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 with SQL "Time" format (HH:mm:ss).

But Power BI trying display this data as "Datetime" and, as result, display only year "1.1.1900".

In Power BI Desktop is all right, and if I publish it displays time right.

But I interested in online solution.

How can I force BI Online with "Time" format.

Thank you in advance.

[ankitpatira · Accepted solution]

@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.

[dsullivan]

Hi,

Is it possible to open a file in sharepoint 365 in Power BI Desktop, then publish it to the service so that the report will update automatically from sharepoint?  

I want to have an excel file on the sharepoint site that we can edit, then have the dashboard update automatically.  

For some reason it was picking up the formatting from excel when I was hosting it from onedrive for business.  From the reading I've done it seems more appropriate to have the file in sharepoint (since 2-3 people edit it), but now it isn't picking up the $ or , in my numbers so instead of $1,000,000 it says 1000000.  

No matter which way you try to go, something major doesn't work with this platform.    

[mailwin33]

@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.

[KHorseman]

Check the data type for that column in your query. I suspect it currently says "Any". Change it to Time and reload the query.

[mailwin33]

@KHorseman, thank you for the reply.

Yes, I checked it, and its type is "Time"