Create authorizations for data source (OneDrive Enterprise) manually

Hi,

Thank you for the help,

I use OneDrive Entreprise (here is a part of my OneDrive) :

The 3 first files in blue are already load in my Power BI Desktop.

The thing is, with the 2 red ones, i can't load them the same way i did with the blue ones :

I make sure to delete the "?web=1 at the end

Initially, I didn't wanted to load it this way, in reality i did a function to load 24 files based on the date (each month of this year and the previous) but i need to create authorization for each files in my OneDrive :

let
Mois = Table.FromRecords({[Moi = "Janvier"], [Moi = "Février"],[Moi = "Mars"],[Moi = "Avril"],[Moi = "Mai"],[Moi = "Juin"],[Moi = "Juillet"],[Moi = "Août"],[Moi = "Septembre"],[Moi = "Octobre"],[Moi = "Novembre"],[Moi = "Décembre"]})
,Annees = Table.FromRecords({[Annee = Text.From(Date.Year(Date.AddDays(DateTime.LocalNow(),-1))-1)], [Annee = Text.From(Date.Year(Date.AddDays(DateTime.LocalNow(),-1)))]})
,MoisAn = Table.AddColumn(Mois, "An", each Annees[Annee])
,MoisAn2 = Table.ExpandListColumn(MoisAn, "An")
,Excels = Table.AddColumn(MoisAn2, "Excel", each Excel.Workbook(Web.Contents("https://********.sharepoint.com/personal/******/Documents/*******/*******/********"& [An] &"*******"& [Moi] &".xlsx"), null, true))

in
Excels

 
 I don't know if this can help you and still sorry for the french version, hope you will recognize the appearance