Forum Discussion
Helper ICreate authorizations for data source (OneDrive Enterprise) manually
Ok, the way the system to load data work is pretty awful honnestly...
I needed to delete all my previous authorizations with OneDrive in my list (like a reset) before retrying to load them the same way I did since the beginning.
This way, Power BI ask me again for me to connect with my professional account and then create the autorizations for my new OneDrive files.
What is weird is that, previously, I was already connected with my professional account for all other autorizations but Power BI didn't use or recognize it and directly told me i couldn't acces to the data source because it was forbidden.
This obviously need to be fix in my opinion
Helper IHi,
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
Helper IOk, the way the system to load data work is pretty awful honnestly...
I needed to delete all my previous authorizations with OneDrive in my list (like a reset) before retrying to load them the same way I did since the beginning.
This way, Power BI ask me again for me to connect with my professional account and then create the autorizations for my new OneDrive files.
What is weird is that, previously, I was already connected with my professional account for all other autorizations but Power BI didn't use or recognize it and directly told me i couldn't acces to the data source because it was forbidden.
This obviously need to be fix in my opinion