SOLVED

Power Query DataSource.Error: ODBC: ERROR Driver not capable.

%3CLINGO-SUB%20id%3D%22lingo-sub-2552363%22%20slang%3D%22en-US%22%3EPower%20Query%20DataSource.Error%3A%20ODBC%3A%20ERROR%20Driver%20not%20capable.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2552363%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20why%20im%20getting%3A%3C%2FP%3E%3CP%3EDataSource.Error%3A%20ODBC%3A%20ERROR%20%5BS1C00%5D%20%5BRocket%20U2%5D%5BU2ODBC%5D%5B2301827%5DDriver%20not%20capable.%3C%2FP%3E%3CP%3EWhat%20is%20caussing%20the%20error.%20can%20i%20find%20any%20additional%20info%20whats%20causing%20the%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20i%20use%20the%20same%20odbc%20driver%20with%20the%20same%20query%20outside%20excel%20i%20get%20the%20data%20no%20problem.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20is%20the%20query%20im%20using%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20Odbc.Query(%22dsn%3DTestServer%22%2C%20%22SELECT%20NR%2C%20DEFKENT%20FROM%20Table%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20field%20NR%20is%20decimal%20and%20the%20field%20DEFKENT%20is%20Varchar%20i%20can%20query%20any%20data%20from%20this%20table%20without%20any%20issue%2C%20but%20as%20soon%20as%20i%20add%20a%20Varchar%20filed%20i%20get%20%22Driver%20not%20capable%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2552363%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2552961%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20DataSource.Error%3A%20ODBC%3A%20ERROR%20Driver%20not%20capable.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2552961%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F358962%22%20target%3D%22_blank%22%3E%40Bjorns163%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FDesktop%2FU2-Universe-database-ODBC-connection%2Fm-p%2F50371%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EU2%20Universe%20database%20ODBC%20connection%20-%20Microsoft%20Power%20BI%20Community%3C%2FA%3E%20old%20thread%20if%20something%20helps.%20That's%20for%20Power%20BI%20Desktop%2C%20but%20Power%20Query%20works%20quite%20similar%20in%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2555373%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20DataSource.Error%3A%20ODBC%3A%20ERROR%20Driver%20not%20capable.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2555373%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20surgestion.%20I%20looked%20into%20this%20but%20unfortunalty%20didnt%20help.%20The%20strange%20thing%20is%20if%20i%20use%20python%20with%20pyodbc%20and%20use%20the%20same%20dsn%20and%20same%20query%20the%20the%20server%20gives%20the%20databack.%20so%20its%20kind%20of%20unknow%20for%20me%20why%20excel%20wont%20except%20the%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Does anyone know why im getting:

DataSource.Error: ODBC: ERROR [S1C00] [Rocket U2][U2ODBC][2301827]Driver not capable.

What is caussing the error. can i find any additional info whats causing the issue?

 

If i use the same odbc driver with the same query outside excel i get the data no problem. 

 

this is the query im using:

  Odbc.Query("dsn=TestServer", "SELECT NR, DEFKENT FROM Table")

 

The field NR is decimal and the field DEFKENT is Varchar i can query any data from this table without any issue, but as soon as i add a Varchar filed i get "Driver not capable"

 

 

3 Replies

@Bjorns163 

Please check this U2 Universe database ODBC connection - Microsoft Power BI Community old thread if something helps. That's for Power BI Desktop, but Power Query works quite similar in Excel.

@Sergei Baklan 

 

Thanks for the surgestion. I looked into this but unfortunalty didnt help. The strange thing is if i use python with pyodbc and use the same dsn and same query the the server gives the databack. so its kind of unknow for me why excel wont except the data.

best response confirmed by Bjorns163 (New Contributor)
Solution
After updating my driver from version 6.1 to 7.2 the issue was resolved.