Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
jass77
New Member

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

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

jass77_1-1697622177420.png

 

Pic 2

jass77_0-1697622160965.png

 

 

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"

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

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.

Thanks for an idea. Definatelly I will. 🙂

lbendlin
Super User
Super User

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

 

lbendlin_0-1697845970951.png

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!