Error 404 DataSource.Error: Web.Contents failed to get contents using Excel file from Sharepoint

---

Anonymous wrote:

Hi guys,

 

Yesterday i created a pbix file local in my desktop and used excel files as sources which located in our Sharepoint map location. During the load at the first time all the files were successfully imported in pbix file.

 

The chosen method for getting this files through my PBI file was:

1. Get Data
2. Web

Today i open the same pbix file and wanted to edit some querys in some tables but get the following message on every querys :

 

 

 

 

 

This are the files from our Sharepoint location:

 

This is screenshot if i click on Go to Error from powerBI desktop

 

This is the URL part from one of the using file :

https://easyconsultancy2.sharepoint.com/sites/VoorspellendsysteemmetbigdataEVnetNL/Shared%20Documents/EVNET%20Usage%20and%20Malfunction/KNMI_WEERSTATION.xlsx

 

 

 

So my wish is to edit querys but as you can see i am stuck with this error.  Any suggestions or solution?

 

 Many thanks,

 

R

---

Anonymous

Can you confirm that the excel still exists in that path in your sharepoint site? What is going on when you open that excel link in a web browser, I've got a 404 error in browser. If the files still exists in the sharepoint site, can you re-try to get data from that excel the way as the yesterday?