Forum Discussion
Power BI dataflow and milliseconds
That is correct.
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. Is there any solution to extracting those milliseconds in Power BI?
Carry the values over in epoch format (or another suitable numerical format). If this is important to you please consider raising it at https://ideas.powerbi.com
When you say "carry the values over", do you mean add new column in SQL that is in milliseconds, or is there a way to get datetime in Power BI to numeric format with milliseconds?
Epoch Time Format seems to be in seconds, not in milliseconds
As a general concept, yes. But you can add fractional parts to the epoch numbers.
Let me see if I can setup a similar scenario on my SQL Server