none
Having Trouble with 64bit ODBC Connector RRS feed

  • Question

  • 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 would show you an image, but my account is new, so it cannot be inserted at the moment.

    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?

    Wednesday, December 26, 2018 11:19 PM

Answers

  • Hi Dan. Can you compare the versions of PQ on the old vs. new computer? I suspect your new computer may actually have an older version of PQ which didn't yet have this dropdown.

    Ehren

    Friday, January 11, 2019 12:10 AM
    Owner