I already posted this in the Desktop forum, but didn't seem to get any answers. I'm fairly certain it's a bug so I'm reposting here. I'm having an issue (Sept 2017 release) where certain values ...
I’ve got response from the Product Team.
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