⏬ Click to check out the description for info and links⏬
Consolidate Multiple files From SharePoint Folder and how to debug and avoid errors
00:00 Intro
00:42 The Setup - Getting the correct folder path
01:54 Change SharePoint.Files to SharePoint.Contents
05:49 Adding new files (including problem files)
07:42 Identifying the problem files
11:15 Changing the Folder Path with the Split Out technique
Warning: to use SharePoint.Contents the user must hace access to to all levels of the SharePoint site.
The SharePoint.Contents method is the better approach for a quicker refresh, but you do need access to the Root SharePoint folder.
Sadly the button is not included in Excel 365 for Business . However you can still use the code
= SharePoint.Contents("YOURPATH/", [ApiVersion = 15])
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Connect with me
wyn.bio.link/
accessanalytic.com.au/
Негізгі бет Тәжірибелік нұсқаулар және стиль How to combine (and debug) Excel files From SharePoint Folder
Пікірлер: 130