Hello, I'm pulling data from a MYSQL server and among the data that I have there several entries which have similar input however they differ from each other by having some of the letters in thei...
This is by design. Power BI workbook uses a case insensitive language setting. As a result, strings in the same column which differ only by cases will be consolidated into a single string depending on whichever happens to be imported first. Query Editor UI displays the strings in the original case before the Import, Data View shows the strings after the Import.
Best Regards,
Herbert