Forum Discussion
Time format in BI Online
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.
Community Championmailwin33 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, 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.
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.
