Getting an excel workbook from a webpage used to work but now it seems to be reading the webpage HTML and throwing an error.
Excel.Workbook(Web.Contents("https://<some directory>/getFile.html?filename=<filename>.xls"), null, true)
It is unbelievably inconvenient and time consuming to download all the files I need to run my power bi reports. Can you please fix this?
Hi @Valazen ,
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://<some directory>/... and delete the credential.
3) Refresh your query. When prompted, reenter your credentials.
Best Regards,Community Support Team _ Caitlyn
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.