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: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

0
Conco1234

[Bug?] Powerquery to Datamodel changes string Capitalization

Submitted by on ‎10-07-2022 08:15 AM

Dear,

 

It has come to my attention that when an attribute contaning a duplicate of data with the same value, but different capitalization, is changed when loading the column from Power Query to PowerBI Data model. Please see example below:

Conco1234_1-1665155559369.pngConco1234_0-1665155539538.png

This suprised me, as there were no additional / user-defined formatting changes applied. This has caused some questionmarks in our team.

 

Thank you for your time, looking forward to a possible explanation (or even a fix).

 

Kind Regards

 

(Credit EdB & CCC)  

 

 

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎10-09-2022 10:56 PM

Hi @Conco1234 

In Desktop view , it is not case aware . But you can edit it in Power Query Editor . For example : 

Ailsamsft_0-1665381275724.pngAilsamsft_1-1665381286335.png

Best Regards,
Community Support Team _ Ailsa Tao

 

Idea Statuses