I dont know where to put this so ill stick it here i guess.
For some reason on Data load in desktop, power bi will try and be smart and auto capitalize lower case letters for no reason.
Can we please turn this functionality off? it really hurts trying to find errors in the data if power bi is fixing them superficially in the front end for us.
@Robert14358 It's likely you are falling victim to Power BI rather ridiculous "case pre-emptivity" "feature".
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.