M365 Show -  Microsoft 365 Digital Workplace Daily

M365 Show - Microsoft 365 Digital Workplace Daily

Microsoft Data Pulse: Power BI, Fabric, Purview

How to Use Power BI Append in Power Query for Data Consolidation

Mirko Peters - M365 Specialist's avatar
Mirko Peters - M365 Specialist
Jun 18, 2025
∙ Paid

You often work with complex data when you analyze trends, such as shifting market shares for smartphone vendors. For example, you might have separate tables for each quarter’s sales. Combining these tables in Power BI append helps you see the complete picture. Power Query makes this process efficient by letting you stack rows from different sources. Whe…

User's avatar

Continue reading this post for free, courtesy of Mirko Peters - M365 Specialist.

Or purchase a paid subscription.
© 2026 Mirko Peters · Publisher Privacy ∙ Publisher Terms
Substack · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture