none
Power Query failure to update from O365 hosted File RRS feed

  • Question

  • I have a Power Query set up across multiple files store on an O365 SharePoint. They had been working up until yesterday where I try to refresh the query without editing and get an error stating:

    "DataSource.Error: The downloaded data is HTML, which is not the expected type. The URL may be wrong, or you may not have provided the right credentials to the server."

    The Query for the source is the following format: "= Excel.Workbook(Web.Contents("https://sharepointsite.com/Documents/Excel File I'm Trying to Reach.xlsx"))

    Nothing was changed on my end and all files (source and power query workbook) all are hosted on the same SharePoint in the same folder.

    Is there a way I can log-in? Strange that it just stopped working.

    Thursday, April 17, 2014 4:59 PM

Answers

  • This might fix your problem:

    1) Go to the Power Query ribbon tab and click on Data Source Settings.

    2) Click on the line with https://sharepointsite.com/... and delete the credential.

    3) Refresh your query. When prompted, reenter your credentials.

    Thanks.

    -Alejandro

    Friday, April 18, 2014 8:44 PM

All replies

  • This might fix your problem:

    1) Go to the Power Query ribbon tab and click on Data Source Settings.

    2) Click on the line with https://sharepointsite.com/... and delete the credential.

    3) Refresh your query. When prompted, reenter your credentials.

    Thanks.

    -Alejandro

    Friday, April 18, 2014 8:44 PM
  • Thanks that did it. The error didn't give directions on how to fix. Thanks again.
    Monday, April 21, 2014 5:12 PM
  • I know this one has already been answered, but occasionally,  deleting the data connection does not solve the problem. In this case, after deleting the data source, create a new connection to the same source - you don't need to keep it, it will ask for credentials, and when you sign-in, it should "fix" your other queries to the same source.

    Thanks, Barbara

    Thursday, September 18, 2014 4:44 PM
  • Thank you! Fixed my issue too. I couldn't fathom what the error meant "The downloaded data is HTML, which is not the expected type." and I did try signing in and out again. Didn't occur to me that the connection was "confused".  
    Monday, April 13, 2015 7:22 PM