Forum Discussion
Solved
Case Sensitivity
I need/want to maintain Case Sensitivity when creating reports. It seems that PowerBi now changes the case on my excel data source as seen on this table visual How can I fix this?
Power Query is case-sensitive, that's why you can add an index there to protect your sensistivity since Power BI is case-insensitive.
This is a huge problem for the architecture/engineering/construction community (BIM/VDC). We want to use the unique IDs of the IFC file format (IFC GUID) for 3D buildings and their data, but it's a case sensitive key.
Example: 2F$L$p5YXH0f$q71wYJpYv
As a result, what should be a simple logical connection becomes a data nightmare.
You can vote on this issue here to encourage Microsoft to allow us the flexibility to have this precision with our data: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Case-sensitive-insensitive-option-in-Power-BI/idi-p/4528490