Forum Discussion
Solved
Power BI dataflow and milliseconds
I have a Power BI dataflow, that fetches data from an OData source. The column in question is of type Date, and clearly includes milliseconds: However, when I connect to the data sou...
That is correct.
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
Did you find any workaround in Power BI side?