locked
Data Connection Error: Error occurred while loading the file RRS feed

  • Question

  • I have a user that gets the following error when trying to change the data connection in Power Pivot from one csv file on his desktop to another csv file on his desktop:

    "An error occurred while loading the file.
    More Details:Failed to connect to the server. Reason: Unspecified error"

    He was able to update this data connection a few months ago.  He can still update connections within the same file in Power Query but not in Power Pivot.  I am not able to replicate the error on my machine.  I tried the following with no resolution:

    1. Provided him with an updated Excel file which I tested with no issues.

    2. Changed the source file from csv to txt.

    3. Moved the files to various locations on his machine.

    Thanks for any help in resolving this error.

    Friday, February 5, 2016 9:09 PM

Answers

  • it may help you.

    http://answers.flyppdevportal.com/categories/sqlserver/sqlkjpowerpivotforexcel.aspx?ID=fecd2fc2-fe1c-4741-9034-8e6aae96b8c7


    Please click Mark As Answer if my post helped.

    • Proposed as answer by Charlie Liao Monday, February 22, 2016 8:56 AM
    • Marked as answer by Charlie Liao Tuesday, February 23, 2016 8:13 AM
    Monday, February 8, 2016 4:16 AM
    Answerer