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...
I spelt Business (BUSSINESS!!) when I correct this, I get all the errors!! Any ideas? Thanks
Hi deeramm33 ,
Are you changing the column name in data source? what is the error looks like?
Best regards,
Morning, Yes Im changing the data source!
error !column 'bussiness unit' of the table was not found
Hi deeramm33 ,
It seems like your query use the column name , please try to verify and change them in the Advanced Editor, Please refer to this document about Advanced Editor: https://docs.microsoft.com/en-us/power-bi/desktop-query-overview#advanced-editor
We suggest you to keep a copy if you want to change it.
Best regards,