Forum Discussion
Adding Milliseconds to Date Time column
Hey,
I want to use Milliseconds on my report to compare two date columns, but I don't see it on the DateTime columns.
The data imported from SQL looks like this:
but on Power BI the data looks like that:
How to transform the columns in order to have milliseconds in the date columns as well?
or (if it's not possible)
How to extract the milliseconds to a different column on Power Query Editor?
Thanks.
3 Replies
Hi - I am running into a similar issue. I am imported data from SQL Database into Power BI. One of the column fields is a datetime type in SQL and shows milliseconds. However, when it is imported into Power BI, the milliseconds go away as Power BI does not support milliseconds in datetime.
The solution you posted suggests that we create a new column in SQL that shows the milliseconds of the time and there is no solution in Power BI to extract the milliseconds?
Can you please detail and explain how to convert the time into precise milliseconds?
