Forum Discussion
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...
Thanks, I took a screenshot of the advanced editor.
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.