Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Has anybody experience this?
In the query editor, I applied Text.Trim to a column to remove leading and trailing spaces. The texts look fine in the editor but when imported, the texts are now in uppercase. Please see screenshot below:
Proud to be a Super User!
Solved! Go to Solution.
Hi @danextian ,
You could vote for this idea: Case sensitive/insensitive option to improve Power BI and make this feature coming sooner.
Hi @danextian ,
After my tests, I found the same result. However, they are not unified to uppercase, but are converted according to the format of the previous value.
Data is not case sensitive in DAX, I think this is the main reason for this result.
Hi @v-eachen-msft ,
Thanks for the feedback. Any idea how to prevent this behavior?
Proud to be a Super User!
Hi @danextian ,
You could vote for this idea: Case sensitive/insensitive option to improve Power BI and make this feature coming sooner.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |