Query Table

Deleted
Not applicable

Capture.PNGI have this error when trying to create a query table by getting external data from an excel file in SharePoint. Can someone tell me how can I fix this error? Or can someone tell me how to create a query table from extenal data (from sharepoint excel)? 

Thank you!

1 Reply

@Deleted 

 

You shall use From Sharepoint Folder connector, after that filter the file and get the object form it. As variant this function works

let
    Source = (siteURL as text, fileName as text, objectName as text) =>

let
    Source = SharePoint.Files(siteURL, [ApiVersion = 15]),
    GetFile = Table.SelectRows(Source, each ([Name] = fileName)),
    GetContent = Excel.Workbook(GetFile{0}[Content]),
    GetObject = Table.SelectRows(GetContent, each ([Name] = objectName)),
    GetData = GetObject{0}[Data]
in
    GetData
in
    Source