Forum Discussion

alexbjorlig's avatar
alexbjorlig
Helper IV
4 years ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    That is correct. 

lbendlin's avatar
lbendlin
Super User
4 years ago

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected outcome.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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?

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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?