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. 

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?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Epoch Time Format seems to be in seconds, not in milliseconds

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Did you find any workaround in Power BI side? 

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago
        let
    Source = #table({"datetest"},{{"2022-05-25 15:30:23.1234"}}),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"datetest", type datetimezone}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each [datetest]- DateTimeZone.From(Date.From([datetest])))
in
    #"Added Custom"

        How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".