How to COMBINE Tables in Power BI
Learn how to combine tables in Power BI by using the "append" function. This allows you to stack similar tables on top of each other, making it easier to measure and compare data from multiple sources. The tutorial demonstrates how to combine task data from multiple projects, but this technique is also useful for survey data and combining data from Microsoft Lists created in multiple sites. The video also addresses the "Formula.Firewall" error that may occur when referencing other queries or steps. The chapters in the video cover querying tables, adding a distinguishing column and unique ID, appending tables to a new query, expanding multi-value fields, and creating relationships. Additional resources and related videos are provided in the description.
Video 1m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time