Forum Discussion
Microsoft Query invalid column name
Hi, I'm trying to import MSSQL view through Microsoft Query import in Data tab. It fails to load most likely due to Czech language encoding (column names) Tried loading it through SQL databas...
janjanacek I had the same problem, and my query was very clean and didn't have much complexity at the moment when I got that message.
I had to go back to the query, unmerged some of my merged columns, i.e. deleted the step, and refreshed all while in the query. After these steps, it was able to load to the table.
So check your merged column steps and refresh all queries before loading to file.