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!
I am currently experiencing issues with string values. In PowerQuery, the table and its values are shown in the correct way, exactly like they are in the database. However, in PowerBI Desktop the values are changed. The problem is in the third column. In PowerQuery, the first row is populated with "support tickets" and the second - "Support tickets". However, in PowerBI Desktop both rows are shown in the same way - "support tickets".
There aren't any changes applied to the table in PowerQuery - only the columns have been renamed. This report has been live for more than a year now and this issue is from this week.
Any help or advice would be greatly appreciated!
Thank you!
Solved! Go to Solution.
Hi @pulpfiction ,
This is by design. Power BI workbook uses a case insensitive language setting. As a result, string in the same column which differ only by cases will be consolidated into a single string depending on whichever happens to be imported first. Query Editor UI displays the strings in the original case before the Import, Data View shows the strings after the Import. You can try the workaruond which provide in the following link:
Data Modeling Uppercase and Lowercase issues
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @pulpfiction ,
This is by design. Power BI workbook uses a case insensitive language setting. As a result, string in the same column which differ only by cases will be consolidated into a single string depending on whichever happens to be imported first. Query Editor UI displays the strings in the original case before the Import, Data View shows the strings after the Import. You can try the workaruond which provide in the following link:
Data Modeling Uppercase and Lowercase issues
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I am posting the screenshots again, as they are too small in the first post.
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |