Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Datasource error (404): Fail to connect sharepoint excel file

Below is the screenshot of the datasoruce error. I have checked the URL is valid but fail to connect to the URL powerbi.

edhans
5 years ago
No. Use the SharePoint connector. I do it all the time. If you are going for one file, connect via SharePoint. Then, once the files are listed, change the SharePoint.Files() function in the formula bar to SharePoint.Contents(). (It is case sensitive)

then drill down to your file. Power query will open it and show you everything in the file, not just one tab. It will also refresh more reliably in the service.

5 Replies

edhans
Community Champion
5 years ago
Question - why are you using the Web.Contents function vs connecting to SharePoint via SharePoint.Files or SharePoint.Contents?
- Anonymous
  Not applicable
  5 years ago
  Because I would like to connect a data to a specific excel file in the sharepoint. I have done a research that if we do so, we should get data from Web.
  - edhans
    Community Champion
    5 years ago
    No. Use the SharePoint connector. I do it all the time. If you are going for one file, connect via SharePoint. Then, once the files are listed, change the SharePoint.Files() function in the formula bar to SharePoint.Contents(). (It is case sensitive)
    
    then drill down to your file. Power query will open it and show you everything in the file, not just one tab. It will also refresh more reliably in the service.