Uploaded April 2025 | Updated September 2026, 1 week ago
Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
🤷🏻♂️365 BUSINESS
Sadly the button is not included in 365 for Business . However you can still use the code in a blank query
= SharePoint.Contents("YOURPATH/", [ApiVersion = 15])
This updated tutorial is your ultimate guide to consolidating multiple Excel files from a OneDrive or SharePoint folder using Excel or Power BI — even when your files contain different sheet names or have empty data. The video walks you through the new OneDrive link changes, explains how to connect with the right URL, and demonstrates how to future-proof your queries by referencing and transforming data dynamically. You'll also learn how to troubleshoot and fix common errors, such as missing sheet names or blank tables, by building a custom error-handling query to identify and isolate problematic files.
🧑🏻🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
🤷🏻♂️365 BUSINESS
Sadly the button is not included in 365 for Business . However you can still use the code in a blank query
= SharePoint.Contents("YOURPATH/", [ApiVersion = 15])
This updated tutorial is your ultimate guide to consolidating multiple Excel files from a OneDrive or SharePoint folder using Excel or Power BI — even when your files contain different sheet names or have empty data. The video walks you through the new OneDrive link changes, explains how to connect with the right URL, and demonstrates how to future-proof your queries by referencing and transforming data dynamically. You'll also learn how to troubleshoot and fix common errors, such as missing sheet names or blank tables, by building a custom error-handling query to identify and isolate problematic files.
🧑🏻🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
