Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

0

[Bug?] Powerquery to Datamodel changes string Capitalization

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
Comments
Anonymous
Not applicable

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