Forum Discussion

LAURADESIMONEEY's avatar
LAURADESIMONEEY
Frequent Visitor
7 years ago

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

 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...
Need Help
LAURADESIMONEEY's avatar
LAURADESIMONEEY
Frequent Visitor
7 years ago

 

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