No distinct value on PowerBI Desktop

[cortazzi]

Hi everyone, 

I have a table on a redshidft DB with the key column line_items_id wich contains 295.030 distinct values.

If I query this view in power query editor I obtain the same result.

Then, when I close and apply my changes on the query editor, on PowerBI Table Mode, the same column returns me 289.440 distinct values. How is that possible ?

Anybody can help me please ?

[Anonymous]

Hi @cortazzi ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @cortazzi ,

I’d like to acknowledge the valuable input provided by the @HotChilli . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 

I have this data and the 7th row has two spaces after the data. In power query editor it shows 7 different values.

But in power bi desktop, it shows 2 different values.

Therefore, Power BI Desktop is usually case insensitive and ignores spaces after data. The Power Query editor is case sensitive. This means that ‘apple’, ‘Apple’ and ‘APPLE’ are treated as different values during the data conversion phase.

More detailed information can be found at the link: Chris Webb's BI Blog: Power BI And Case Sensitivity (crossjoin.co.uk)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cortazzi]

Hi Clara, thanks for the clarification.

But the issue is not related to case sensitivity. 

The table/view I'm querying presents distincts value on that column

It's very strange that on redshift DB and PBI query editor I ve just one row, while In PowerBI Desktop, four rows.

It seems a bug. I don't know hot to solve it 

[Anonymous · Accepted solution]

Hi @cortazzi ,

This is my original data.

This is the filtered data.

It shows all the data with ‘A’. So, please check your other steps or actions, maybe some unintentional actions are giving you unexpected results. You can test it step by step in power query to narrow down and check the exact cause.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

I think we have a misunderstanding. I mean that you find 2 line_items_id that has the same letters but different case, for example, AAb    AaB

They will exist like this in Power Query as 2 distinct values but in DAX /powerbi data view, they are the same value so will count as 1 distinct value due to case-insensitivity

[cortazzi]

Here an example.

Line Item : nEatQAlEjq

PBI Desktop

Query Editor

[HotChilli]

Possibly down to different case-sensitivity in DAX than Power Query.

You only need to find one example in your data to prove this.

[cortazzi]

Hi @HotChilli thanks.

Here an example.

Line Item : nEatQAlEjq

PBI Desktop

Query Editor