Forum Discussion
How to bin small decimal values
Hello, I recently tried to create a histogram in Power BI from some data that ranged between 0 and 0.140. I right clicked the data and created a a new group. I selected Group Type to be "bin" and...
It turns out to be a problem in the Kusto connector. Fixes are planned. One work around is to bin it in the query. This works today.
let
Source = Kusto.Contents("<cluster>", "<database>", "<table> | extend slack_bin=bin(slack, 0.01)", [MaxRows=null, MaxSize=null, NoTruncate=null, AdditionalSetStatements=null])
in
Source
Thanks for trying. Not sure what the difference is. My guess would be that you are not using Direct Query and a Kusto connection. I checked my version and found this:
Version: 2.76.5678.782 64-bit (December 2019)
I will also mention that 2 other people I know tried and also reproduced the same error. So, it wasn't just me.
Yep, I'm just using Import with an Enter Data query so my suspicion would be that this is some kind of problem with DirectQuery.
It turns out to be a problem in the Kusto connector. Fixes are planned. One work around is to bin it in the query. This works today.
let
Source = Kusto.Contents("<cluster>", "<database>", "<table> | extend slack_bin=bin(slack, 0.01)", [MaxRows=null, MaxSize=null, NoTruncate=null, AdditionalSetStatements=null])
in
Source