Forum Discussion
More Distinct/Unique values than rows in table
we have a similar issue in PowerBI. we're trying to import datetime column from ADX to PowerBI and we can see that the number of distinct values are more than the unique values. the unique value count matches what we have in our ADX data but there seems to be some extra distinct values getting added by PowerBI.
we tried importing the datetime as text and then clean the text column and it seems like that fixes the issue but it means we have to switch to import mode which is not ideal for us.
You can also reproduce our issue using the following Kusto queries:
`range TimeGenerated from datetime(2024-01-01T21:30:00.000Z) to datetime(2024-01-08T23:50:00.000Z) step 10m` gives us 1023 unique and distinct values
but
`range TimeGenerated from datetime(2024-01-01T21:10:00.000Z) to datetime(2024-01-08T23:50:00.000Z) step 10m` gives us1016 distinct and 1025 unique values
which is quite strange. any help is appreciated