Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Column Name Error after Data Source Change

Hi Gurus, I have run into a problem after I changed my data source from SQL server to a local excel file. I used the Advanced Editor and it worked fine. But when I click "Close and Apply" it gives...
Need Help
mussaenda's avatar
mussaenda
Community Champion
6 years ago

It happens when you have a calculated column with the same name,

or on your advance editor, you are trying to put this as column editor.

 

Yes Advance Editor will not show you error because it checks the syntax.

Try looking at your advance editor again and check each step you make especially when adding custom or conditional columns.

 

If you want, You can screenshot your advance editor here and cover the confidential data to help you find the error.

If the error cannot be found on adnvance editor, it can be on your dax column name

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks, I took a screenshot of the advanced editor.

  • mussaenda's avatar
    mussaenda
    Community Champion
    6 years ago

    Have you tried  to remove the promoted headers to see if the error will still show?

    No, stupid question. Sorry. Of course it will not show because there will be "Column 1" etc. Sorry.

     

    For what I understand, we need to find the two columns with the same name

     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Based on my test, if there are same column name in excel, the promote header function will rename them automatically. So I think the problem will be the calculate table or column as  mussaenda  mentioned.

     

     

    Can you try to connect to this excel file in a empty pbix file to see if it still has error?

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.