Forum Discussion
Upper Case Changed to Lower Case in Data Set but Power BI does not Change
Hi.
Yes I implemented those Power Query steps in Transform Data of Power BI Desktop and works....amazingly. You say this works as designed. I can't believe this. This means anyone using Paginated Reports displaying data from the Semantic Model will have case changes. I don't see this as by design. I see this as a carry over issue from bringing SSRS into Power BI. If this was by design you wouldn't need these ridiculous steps to persist case - you'd have a toggle or one command. This needs fixing and is a bug carried over from the port. This is definately not what you would want to happen by design for Paginated Reports.
Just to add. The example shown gives adding special characters on end of Lowercase characters. If we only have a few upper case characters will it still work if I added the special case characters to Uppercase characters? Haven't tried this. ** Be warned ** This will break your wrapping of text in a Power BI Report Builder field. The fix is to remove the special characters in the DAX or as I did on the field:
Replace(Fields!YourFieldName.Value, ChrW(8203), "")
This retains case and fixes the wrap issue as problem was getting the correct case into Report Builder initially. Once it's in you can remove these characters. Very messy and something Microsoft SHOULD be fixing.