cancel
Showing results for 
Search instead for 
Did you mean: 

Excel.Workbook Web.Contents no longer reading excel file

Getting an excel workbook from a webpage used to work but now it seems to be reading the webpage HTML and throwing an error.

Valazen_1-1653599584824.png

 

 

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?

Status: Investigating

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

 

 

 

Comments
v-caitlyn-mstf
Community Support
Status changed to: Investigating

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