Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

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 suc...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Eric_Zhang I'm having the exact same kind of issue for one specific file that I'm trying to connect to.

The file is located in OneDrive and I have no problem to access the file with same URL in for example a browser. 

When changing from https to http I'm able to access the file but I really need to use https to be able to use a organizational account once the report is published to Power Bi Service.

 

I have tried to delete the file and upload it again to OneDrive but still get the same error. 

I'm connecting to many other files using same method without issues but this specific file will not work! 

 

Br,
Magnus

trevorgermain's avatar
trevorgermain
Advocate I
8 years ago

I have a similar issue. I used Web.Contents to get data from a Web Api. It works fine in Desktop, but when I publish it, I get prompted to authenticate, even though anonymous authentication should be supported. I get a 404 error even though the same query works fine in Desktop.