Problem when using RelativePath option of Web.Contents() for excel files on Sharepoint

[Haonan]

Hi,

The problem I faced was very similar to the one here.

I need to access an excel file on sharepoint, and the entire url is like:

"https://xxxxxx.sharepoint.com/sites/SBM/Lists/db_Ist/Attachments/68/stand Juli 22/07/xlsx"

The account I was using to sign in has full access to this path.

Since the path is dynamic, my code is as follows:

let
  #"open_table" = Excel.Workbook(Web.Contents("https:/xxxxx.sharepoint.com",
                                 [RelativePath =
                                 "sites/SBM/Lists/db_Ist/Attachments/68/stand Juli 22.07.xlsx"]))
in
  #"open_table"

and then i got the error:

I tried the solution in the above link, change the URL by replacing https with http, then i got:

i cant even sign in with my account.

Does anybody know of an other way to go about doing this? Thanks a lot!!

[lbendlin]

1. clear global permissions for that data source and re-authenticate.

2. Don't use the web connector. Use the Sharepoint Folders connector.  There you can handle the dynamic file names much easier.