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%20noopener%20noreferrer%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
Highlighted
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
Highlighted
Why do you have to use MSQuery? Alternatively, why not use the more modern tools (Get&Transform from the Data tab)?
Highlighted

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

Highlighted
Highlighted

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