Home

System DSN Dropdown for ODBC Connections Not Loading in Power Query in Excel

danzrust
Occasional Visitor

Hi guys,

I don't see my installed system DSNs when trying to connect to ODBC source in Power Query. The dropdown menu simply does not show up. I dont see the highlighted part:

ODBC.PNG

I have a brand new laptop. Win 10, 64 bit. 

I installed Excel 64 bit.

I installed Simba Driver 64bit for Big Query and setup System DSN via "Setup ODBC" menu in Win 10. Tested connection, everything works.

 

I go to Excel, try to add a new source in Power Query > ODBC > I don't see the dropdown menu at all where the System DSN is supposed to be selected.

 

When I try the same thing in Power BI, I see the dropdown menu. I can select the desired System DSN and everything works ok so something must be wrong on the Excel front.

 

I also have an old PC sitting next to me where everything works OK (also setup by me few months ago).

Any ideas what could be wrong?

Related Conversations
Sorting problem with imported data from query
DenisL in Excel on
5 Replies
Excel doc very slow
Lucas Fernandes de Jesus in Excel on
7 Replies
Deleting a connection on Excel
Lucas Fernandes de Jesus in Excel on
2 Replies
Excel ComboBox (ActiveX Controls) dropdown not functioning
Kpizzle in Excel on
1 Replies
Excel web query DataFormat.Error "not a valid path"
Simon Pearce in Excel on
7 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies