Forum Discussion
Helper IIITime Format in Power BI Web service
Helper III
I am using Power BI webservice to build the report.
What you mentioned is Power BI desktop. This is what I have.
Community Championahsanlhcgov If possible please install Power BI desktop and do the changes.
I think we can't change the type of a column from the Power BI service.
Also, try to change the column type in the source file. Refer to this link - https://www.extendoffice.com/documents/excel/3526-excel-convert-datetime-to-date.html
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
- ahsanlhcgov
I have installed Power BI desktop but it does not allow a live connection to excel files.
is there anyway I can create a live connection which updates my published reports?
Thank you.
- nandukrishnavs
ahsanlhcgov Excel source will not support live connection. Sources like SQL will support DirectQuery. Could you elaborate on your requirement and current implementation?