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

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".