Forum Discussion
Different capitalization in Power Query and loaded data
Hi, I am seeing a problem when importing data where certain columns change capitalization when they are loaded into the report. I attach a screenshot with such case, where in Power Query I see on...
Hi,
The problem is that I have several entries with the same text, but different capitalization. In Power Query I see the different capitalization, but once imported, everything has the same capitalization, which means some will be wrong.
My guess is that vertipaq stores the first occurrence of the cell and applies it to the other occurrences, regardless of the capitalization and this is causing the issue.
I am also on a Report Server On Premise, so no May 2021 update for me yet.
The issue you reported is exactely what is happening to me as well.