Time Format in Power BI Web service

Question

&nbsp;Hi Community,&nbsp;&nbsp;I have a BI report using an excel file stored in one drive. the application date column is showing some dates with time. how can I change this?&nbsp;The language settings are English UK for Chrome and Power BI is set to use browser language.&nbsp;&nbsp;&nbsp;&nbsp;

nandukrishnavs · Answer

ahsanlhcgov&nbsp;&nbsp;you could try to change the data type of that particular column.&nbsp;Option 1&nbsp;&nbsp;Option 2&nbsp;&nbsp;Did I answer your question? Mark my post as a solution!Appreciate with a kudos 🙂

ahsanlhcgov · Answer

hi&nbsp;nandukrishnavs&nbsp;&nbsp;I am using Power BI webservice to build the report.&nbsp;&nbsp;What you mentioned is Power BI desktop. This is what I have.&nbsp;&nbsp;

nandukrishnavs · Answer

ahsanlhcgov&nbsp; If possible please install Power BI desktop and do the changes.&nbsp;I think we can't change the type of a column from the Power BI service.&nbsp;Also, try to change the column type in the source file. Refer to this link -&nbsp;https://www.extendoffice.com/documents/excel/3526-excel-convert-datetime-to-date.html&nbsp;Did I answer your question? Mark my post as a solution!Appreciate with a kudos 🙂&nbsp;

anonymous · Answer

ahsanlhcgov&nbsp;It is recommend to use desktop to connect to data source which is much better in modelling and format reports, then simply publish to service.&nbsp;&nbsp;You can not change the date type and format in service, the only option is to change the date/time to date in the excel on onedrive.&nbsp;Paul Zheng _ Community Support TeamIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.&nbsp;&nbsp;