• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cant Connect to Data source via Power Query

Dokat

Member
Hi,

I am using power query via external connection to load data. However I am receiving unable to connect error message. Please see below error message. Did anyone come across same issue and have a solve for it? Thank you

upload_2016-12-30_13-46-58.png
 
There are 2 common reasons that I know of.
  1. Faulty add-in enabled for Office applications
    • Check your add-in and turn off all but PowerQuery and see what happens.
    • Uninstall and re-install PowerQuery add-in (if using Excel 2013 or 2010)
  2. Issue with Connector/Provider
    • Download the engine and install
    • If using 64 bit windows and 64 bit office above may not work. Use THIS instead.
If one of the above does not resolve issue...

Check your machine's event log immediately after that error is generated and find log pertaining to that error. Dump to text. And ask at Microsoft support for help with that info.
 
Back
Top