Column Name Is Different in Power BI Than SQL View

  • Hi all,

    Using Snowflake.

    When I Describe my View the first columns shows as Nielsen Market Name (KUSA Adjusted) VARCHAR (10000)

    I connected to the View from Power BI Desktop (PBID)

    However, in PBID, the name of the column is showing as Nielsen Market Name (USA Adjusted) - the "K" has been dropped from the middle of the string.

    Any ideas why that might be?

     

    Thanks,

    w

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • As a completely random guess, are you renaming the column inside PowerBI at the presentation layer?

    As far as I am aware, PowerBI shouldn't be renaming columns on you.

    Alternately, any chance the view has a typo and the K is missing but exists at the table level?

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply