locked
Constantly need to reestablish connection RRS feed

  • Question

  • Several power query files were created in Excel2013.  They connected to SQL via ODBC DSN.  Opening any of them using Excel2016 requires me to establish the connection each time I open the file.  I save the report when I am done but when I open the file again I need to go through the whole process of connecting.  In Excel 2013 I only needed to open the file and run the query because it was always connected to that workbook.

    Is there something I'm missing? How can I get Excel2016 to "remember" the connection? Or, what do I need to do to the file so it remembers the connection when accessed in Excel2016?

    Wednesday, March 1, 2017 3:44 PM

Answers

  • Can you elaborate on what you mean by requiring you to establish the connection? Are you getting prompted for credentials? Can you share the M from your query?

    Thanks,
    David

    Thursday, March 2, 2017 12:57 AM