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".
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.