CPPUG: Appending daily spreadsheets into one report with Power BI & SharePoint

Why we picked it

Hello Visionaries and Innovators! Ever spent your morning copying yesterday's spreadsheet into a master file, only to do it again tomorrow? You're not alone, and there's a much better way. Join the Calgary Power Platform User Group for a hands-on group learning session where we'll show you how to automatically append daily spreadsheets into a single, refreshable Power BI report using SharePoint as the data hub. No more manual copy-paste, no more "which version is the right one?" #### What You'll Learn * Setting up a SharePoint folder structure that plays nicely with Power BI * Using Power Query to combine multiple files into one clean dataset * Building a refreshable report that picks up new files automatically * Handling the common gotchas: mismatched columns, file locks, and schema drift #### How It Works This is small-group learning, capped at 8 spots. Ryley will walk through the full build start to finish, then you'll have time to try it yourself with the Bauer Automate team c