Forum Discussion

Luklaman's avatar
Luklaman
Regular Visitor
5 years ago

Bugs

Hi, I think I have found two bugs in PBI and am interested to know if people think they are bugs, or have experienced these issues. I have a PBI report combining 20+ Excel files from multiple differe...
Need Help
MattAllington's avatar
MattAllington
Community Champion
5 years ago

Power Query is case sensitive, so American Airlines is not the same as american airlines. DAX is not case sensitive, so if you load those 2 records into Power BI, they will be treated as being identical. 

you can and should

1. Trim spaces from your column values

2. Clean the columns (this removes non printing characters tha you can't see)

3. Standardise the capitalisation

 

all these steps can be completed from the Power Query transform menu. 

see if that helps. 

  • Luklaman's avatar
    Luklaman
    Regular Visitor
    5 years ago

    Thanks Matt.

     

    That has resolved one of the vendors, however I still have two vendors that have not been removed.  I have a vendor called "AMERICAN" and it appears as such in the raw data and the query used to flag Internal vendors.  American is in upper case in both tables and is 8 characters long, but despite this "AMERICAN" remains flagged as an internal vendor.

    • MattAllington's avatar
      MattAllington
      Community Champion
      5 years ago

      These things can be challenging because you can't "see" what is happening. Try adding a step in each table query that filters just for the problem item before they are joined. This may help you see what is happening.