Data Flow - specify how to connect after filename change

[123456789123456]

Hi,

I'm using a dataflow to transform an unordered/untabled excel into something useful for a couple of datasets.
This was working fine with the 2020.xlsx file. Sadly it got removed from the sharepoint and is now the 2021.xlsx file.
the small change needed to be done - change the web contents url from ...2020 to ...2021 is causing issues.

The "Please specify how to connect." message will pop up and login/logout changes don't help at all. How can I deal with this really basic problem?

Codepart leading to error:

let
Source = Excel.Workbook(Web.Contents("https://someones.sharepoint.com/sites/aFolder/2021.xlsx"), null, true),
#"Importantlist" = Source{[Item = "Importantlist", Kind = "Sheet"]}[Data]
in
#"Importantlist"

Thanks for your help

[lbendlin · Accepted solution]

Go to Data Source Settings  and clean out the old permissions.

Generally you want to avoid hard coding the file name in the source string. Use the Folder connector instead and then filter down to the file you want.

[123456789123456]

Thank you. That was as easy as I thought.

I stopped using the SP Folder Connector as I was forced to use a SP with tens of thousands of csv files on it - I'll however follow you advise when not connecting to said SP