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
Excel file not opening
mmirfan in Excel on
0 Replies
Excel Add-In - Visio Data Visualiser - Sign in issue
MrWLJ71 in Excel on
0 Replies
Macro Not working
Rajeev_Raghavan in Excel on
3 Replies
Need Help Creating This Formula
James Reuland in Excel on
0 Replies
Excel Find and replace
Brickson_Dimas in Excel on
2 Replies