Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

0
calal309

Data different between Power Query and table view

Submitted by on ‎05-19-2023 01:02 AM

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.

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎05-21-2023 11:19 PM

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

vyetao1msft_0-1684735388238.png

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses