Forum Discussion

Copper Contributor

Jul 15, 2021

Solved

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

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

excel

Bjorns163
Jul 30, 2021
After updating my driver from version 6.1 to 7.2 the issue was resolved.

SergeiBaklan

Diamond Contributor

Jul 15, 2021

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.

Bjorns163
Copper Contributor
Jul 16, 2021
SergeiBaklan

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.
- Bjorns163
  Copper Contributor
  Jul 30, 2021
  After updating my driver from version 6.1 to 7.2 the issue was resolved.