web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / User groups / Calgary Power Platform User Group / CPPUG: Appending daily spreadsheets into one report with Power BI & SharePoint
Learning

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

6/24/2026 10:30:00 PM | 6/24/2026 10:30:00 PM to 6/25/2026 12:00:00 AM (UTC-07:00) Mountain Time (US & Canada) | 1 registered

6/24/2026 10:30:00 PM 6/24/2026 10:30:00 PM - 6/25/2026 12:00:00 AM 6/25/2026 12:00:00 AM (UTC-07:00) Mountain Time (US & Canada) | 1 registered

Register   Add to calendar
Location

Solarium Boardroom 2nd Floor, 1206 20 Avenue SE, Calgary, AB, Canada

Meeting link
Speakers
Topics

Appending Daily Spreadsheets Into One Report with Power BI and SharePoint

Details
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 circulating to help anyone who gets stuck. Think of it as a workshop, not a lecture; you'll leave with a working report, not just notes.

 

What to Bring

  • Your laptop with Power BI Desktop installed
  • Access to a SharePoint site you can test in (a sample environment will be available if you don't have one)
  • A real-world reporting headache you'd like to solve

 

Event Format

  • 4:30 - 4:40pm (10 mins): Setup (getting you set up with the wifi, setting up your laptops, etc.)
  • 4:40 - 5:30pm (50 mins): Live walkthrough with Ryley
  • 5:30pm - 6:30pm (30 mins): Hands-on build with BA team support

 

Why Your RSVP Matters

Spots are capped at 8, and our team invests real prep time to make sure each session runs smoothly. If you RSVP, please commit to showing up. Plans change, we get it; just cancel as early as you can so we can free your spot for someone on the waitlist.

 

About the Calgary Power Platform User Group

We are a thriving community of Power Platform enthusiasts dedicated to learning, sharing, and growing together. From Power Automate and Power BI to Power Apps, Power Pages, Dataverse, AI Builder, and beyond, we're passionate about empowering individuals and organizations through technology.
Notes:
  1. If you confirm to attend, please regularly check your Meet Up chat messages for any updates.
  2. Your $5 Community Contribution is more than just a ticket; it's a gateway to making a meaningful impact. This gesture unites us in selecting and supporting a cause reflective of our collective ethos. Rest assured, this contribution is purely for charitable purposes, with no part used by the event organizers.
 

Events you might like

11/27/2026 6:30:00 PM 11/27/2026 6:30:00 PM (UTC) Dublin, Edinburgh, Lisbon, London

Devon and Cornwall Power Platform User Group | Q4 | Virtual

Host group Devon and Cornwall Power Platform User Group

TBC

Online

6/22/2026 8:00:00 AM 6/22/2026 8:00:00 AM (UTC) Dublin, Edinburgh, Lisbon, London

Cambridge Power Platform User Group: Spring Sessions

Host group Cambridge Power Platform User Group

Clarissa Gillingham ,  Douglas Romao ,  Lesley Crook,  Sharon Sumner ,  Zoe Wilson

Online

6/18/2026 5:30:00 PM 6/18/2026 5:30:00 PM (UTC-08:00) Pacific Time (US & Canada)

Copilot Collective OC: Founding Members Session

Host group Copilot Collective OC

Delia Zuniga

Aliso Viejo, CA, United States

Your message has been sent!