Forum Discussion
Sharepoint file not updated
I wonder why you're using a Sharepoint folder connection when you are connecting to a single file only as shown in your query. That aside, are you able to see the missing rows in the query editor? What about in the preview prior to connecting to the worksheet itself?
If you don't see those lines, try adding InferSheetDimensions option to Excel.Workbook
Excel.Workbook(#"xxx xlsx_https://xxx sharepoint com/sites/xxx/Shared Documents/Customer team management/xxx/xxx/", [InferSheetDimensions = true])
Thank you, adding
[InferSheetDimensions = true]
did resolve the issue. 🙂 I did not see the missing rows in the preview prior to connecting to the worksheet itself.
And regarding your question about the Sharepoint Folder - if I am connecting to only one file from a Sharepoint folder, would the Web connector be the best choice?
Super UserThe SharePoint folder connector can become quite slow, especially as the site grows in size. The more files it contains, the longer it takes to load. It's often better to use the Web connector instead. If you do need to connect to a SharePoint folder, consider using SharePoint.Contents, which lets you navigate the site’s folder structure hierarchically and can offer better performance and control.
Exce.Workbook(Web.Contents(<complete path>) )