How to consolidate multiple files from a SharePoint folder using Power Query in Excel and Power BI.
🔽 More Info below PLUS warning 🔽


Warning: to use SharePoint.Contents the user must hace access to to all levels of the SharePoint site.


Additional technique to speed up refresh using incremental refresh
[ Ссылка ]


Sadly the button is not included in 365 for Business . However you can still use the code

= SharePoint.Contents("YOURPATH/", [ApiVersion = 15])



Video I mention explaining the consolidation helper queries
[ Ссылка ]




The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. [ Ссылка ]

Did you know I've written a book "Power BI for the Excel Analyst"?
[ Ссылка ]


Connect with me
[ Ссылка ]

свернуть