Forum Discussion
Solved
DateTime Datatype not pulling through to Power BI from Tabular editor to Power BI
Hi All, I am setting a datatype to DateTime in Tabular editor, in the Database it is a DateTime field but when I pull it through to PowerBI it's keeping the Date but losing the time. Any id...
Hi,
I figured it out, I had to provide the Format string in Tabular editor for it to be pulled through correctly , although the datatype was DateTime.
It had to have it as dd/MM/yyyy HH:mm:ss.
Thanks
amitchandak
Super User
Super UserBIttaM , Please check the data type in Power Query. If it is date there, it might lose time.
Other wise along with datetime, choose a format to display time
Hi,
I figured it out, I had to provide the Format string in Tabular editor for it to be pulled through correctly , although the datatype was DateTime.
It had to have it as dd/MM/yyyy HH:mm:ss.
Thanks