Forum Discussion
"Microsoft.Mashup.Engine1.Library.Resources.HttpResource"
Hi LAURADESIMONEEY ,
How could you get the file and what kind of file you want to get from SharePoint? LIst or folder or excel/Csv saved in SharePoint? Could you have checked your credentials for your data or you could clear the permissions to re-log in your credentials:
Regards,
Daniel He
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
