Jul 15 2019 10:32 AM
Jul 15 2019 10:32 AM
I 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!
Jul 15 2019 11:26 AM
@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