Forum Discussion
"Microsoft.Mashup.Engine1.Library.Resources.HttpResource"
Hi,
I need to get data from folders and excel files in onedrive. Till now for the connection to the files included in a folder I used this:
let
Origine = SharePoint.Files("https://xxxx-my.sharepoint.com/personal/xxxxx_emailextension1_emailextention2_com", [ApiVersion = 15]),
#"Filtrate righe" = Table.SelectRows(Origine, each [Extension] = ".xlsx" and [Folder Path] = "https://xxxx-my.sharepoint.com/personal/xxxxx_emailextension1_emailextention2_com/Documents/Namefolder1/Namefolder2/"),
#"DB_PON" = #"Filtrate righe"{[Name="filename.xlsx",#"Folder Path"="https://xxxx-my.sharepoint.com/personal/xxxxx_emailextension1_emailextention2_com/Documents/Documents/Namefolder1/Namefolder2/"]}[Content],
#"Imported Excel" = Excel.Workbook(#"DB_PON "),
Elenco_progetti_totali_Sheet = #"Imported Excel"{[Item="progetti",Kind="Sheet"]}[Data],....."
Now this type of connections are not working anymore. When I try to modify the credentials I can't se the OAuht authentication
I tried to connect with Anonimous / Windows / Microsoft but is not working.
Thanks in advance.
Laura
Hi LAURADESIMONEEY ,
Based on my test, it could work on my side with Sharepoint folder and I could not understand "I need to get data from folders and excel files in onedrive."
The problem you have met with is in Sharepoint folder or excel file in OneDrive? From your first error information, it seemed that your Sharepoint URL is not correct, you may refer to below link to make sure your URL is correct:
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
Regards,
Daniel He