Data different between Power Query and table view

[calal309]

I have found some text values in an ID column of my data where the last letter of the ID has been capitalised. It has only occured twice out of hundreds of records. In Power Query, the case is correct. When looking at the same data in a Table visual, the last character has been capitalised.

[Anonymous]

Hi @calal309 

Desktop pages do not distinguish between upper and lower case. If you want the Desktop and Power query to display the same, then you can refer to the action in the link below.

How to use M language to solve the problem that the Power BI engine is not case sensitive - Zhihu

Best Regards,
Community Support Team _ Ailsa Tao