Microsoft Query invalid column name

%3CLINGO-SUB%20id%3D%22lingo-sub-1205887%22%20slang%3D%22en-US%22%3EMicrosoft%20Query%20invalid%20column%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1205887%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20import%20MSSQL%20view%20through%20Microsoft%20Query%20import%20in%20Data%20tab.%20It%20fails%20to%20load%20most%20likely%20due%20to%20Czech%20language%20encoding%20(column%20names)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel.PNG%22%20style%3D%22width%3A%20559px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F174659i32EA31FF099B7E03%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22excel.PNG%22%20alt%3D%22excel.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ETried%20loading%20it%20through%20SQL%20database%20option%20and%20it%20worked%2C%20unfortunately%20I%20have%20to%20use%20Microsoft%20Query%20importing%20option.%20Double%20checked%20excel%20language%20settings%20and%20seemed%20fine%20to%20me.%20I%20ran%20out%20of%20ideas%20here%20fellas.%20Appreciate%20any%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1205887%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1206079%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Query%20invalid%20column%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1206079%22%20slang%3D%22en-US%22%3EWhy%20do%20you%20have%20to%20use%20MSQuery%3F%20Alternatively%2C%20why%20not%20use%20the%20more%20modern%20tools%20(Get%26amp%3BTransform%20from%20the%20Data%20tab)%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1206166%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Query%20invalid%20column%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1206166%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3EI%20need%20to%20use%20parameters%20to%20filter%20my%20query%20and%20unfortunately%20only%20Microsoft%20Query%20supports%20that%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1206200%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Query%20invalid%20column%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1206200%22%20slang%3D%22en-US%22%3EYou%20can%20do%20this%20using%20PowerQuery%2C%20see%3A%20%3CA%20href%3D%22https%3A%2F%2Freevessmith.wordpress.com%2F2014%2F08%2F19%2Fpower-query-and-stored-procedures-with-parameters%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Freevessmith.wordpress.com%2F2014%2F08%2F19%2Fpower-query-and-stored-procedures-with-parameters%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1828942%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Query%20invalid%20column%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1828942%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572976%22%20target%3D%22_blank%22%3E%40janjanacek%3C%2FA%3E%26nbsp%3BI%20had%20the%20same%20problem%2C%20and%20my%20query%20was%20very%20clean%20and%20didn't%20have%20much%20complexity%20at%20the%20moment%20when%20I%20got%20that%20message.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20to%20go%20back%20to%20the%20query%2C%20unmerged%20some%20of%20my%20merged%20columns%2C%20i.e.%20deleted%20the%20step%2C%20and%20refreshed%20all%20while%20in%20the%20query.%20After%20these%20steps%2C%20it%20was%20able%20to%20load%20to%20the%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20check%20your%20merged%20column%20steps%20and%20refresh%20all%20queries%20before%20loading%20to%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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)

excel.PNG

Tried loading it through SQL database option and it worked, unfortunately I have to use Microsoft Query importing option. Double checked excel language settings and seemed fine to me. I ran out of ideas here fellas. Appreciate any help!

4 Replies
Why do you have to use MSQuery? Alternatively, why not use the more modern tools (Get&Transform from the Data tab)?

@Jan Karel PieterseI need to use parameters to filter my query and unfortunately only Microsoft Query supports that

@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.