Helper IISplitting column by delimiter - Data not showing in table when closing query editor
I have tried multiple times to split a column with date/time by the space delimiter. This works in the power query editor, but once i close and apply and try and view the data in the table, the time column has no data in it, only the date. After reading other posts, i tried deleting and reloading the table, i tried restarting PBI, i tried restarting my PC, and i'm not sure what other options i have. i have loaded this same table and done this same step before without any issues. What could be causing this now?
3 Comments
Do you use Power BI Desktop October release? I am unable to reproduce this issue in this version of Power BI.
Instead of spliting column in Power BI Desktop query editor, you can create date and time columns using DAX. After creating the columns, change data type of Date column to Date, and change data type of Time column to Time.Date = Table[TRANSFER_DATE].[Date]
Time = TIMEVALUE(Table[TRANSFER_DATE])
Regards,
Lydia
KWelsh8144Anonymous Yes I'm using the Oct 18 version.
While I couldn't resolve my issue, youre alternate solution worked for me.
Thank you!
