Rounded Time set in rows work in PBI Desktop but disapears afrer first refresh in Power BI service!

[jass77]

Dear All, 

I have a very simple table (Pic 1) with rounded hours and measures that count a number of calls within. In desktop PBI it works fine, but once it is published and after the first refresh all rows that show rounded hours disappear (pic two)

Pic 1

Pic 2

This is how the time table is created. I tried everything... to change data type, from type to text and different formats but nothing helped. Did anybody have a similar problem? Thank you in advance

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Tdk7ClgH.......(cut)  3nu483Xm683Tn6c7TnfefO//+Aw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Time (HH:mm)" = _t]),

 #"Changed Type" = Table.TransformColumnTypes(Source,{{"Time (HH:mm)", type time}}),
#"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "Time (HH:mm)", "Time (HH:mm) - Copy"),
#"Calculated Start of Hour" = Table.TransformColumns(#"Duplicated Column",{{"Time (HH:mm) - Copy", Time.StartOfHour, type time}}),
#"Renamed Columns" = Table.RenameColumns(#"Calculated Start of Hour",{{"Time (HH:mm) - Copy", "Time (00:00) Rounded"}}),
#"Calculated Start of Hour1" = Table.TransformColumns(#"Renamed Columns",{{"Time (00:00) Rounded", Time.StartOfHour, type time}})
in
#"Calculated Start of Hour1"

[lbendlin · Accepted solution]

I am proposing a slightly different data model - give that a try.

Note:  There seem to be a lot of time value rounding issues at the moment. I had something similar in a totally different case. Wonder if they introduced a bug.

[jass77]

Thanks for an idea. Definatelly I will. 🙂

[lbendlin]

Please include the complete Power Query code or provide sample data in other usable format.