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...
amitchandak
Super User
Super User
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?