"Microsoft.Mashup.Engine1.Library.Resources.HttpResource"

[LAURADESIMONEEY]

 I have an issue regarding the connection to Sharepoint.Files with all the dashboards connected  (API 15) .
This is the url that I used till now and it was working till Yesterday.

https://xxxx-my.sharepoint.com/personal/xxxxxx_emailextension1_emailexension2_com
This is the error:

Dettagli: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Richiesta non riuscita:
Versione OData: 3 e 4, errore: The remote server returned an error: (404) Not Found. (Not Found)
Versione OData: 4, errore: The remote server returned an error: (404) Not Found. (Not Found)
Versione OData: 3, errore: The remote server returned an error: (404) Not Found. (Not Found)"

I tried to change the API, I deleted the cache memory, I tried to change the data origin but is still not working.
Could someone help me?

[v-danhe-msft]

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:

https://www.c-sharpcorner.com/article/edit-or-remove-permission-from-existing-data-source-connection... 

Regards,

Daniel He

[LAURADESIMONEEY]

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/Namefold..."),
    #"DB_PON" = #"Filtrate righe"{[Name="filename.xlsx",#"Folder Path"="https://xxxx-my.sharepoint.com/personal/xxxxx_emailextension1_emailextention2_com/Documents/Document...],
    #"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

[v-danhe-msft]

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