Appending Queries in Power Query (Power BI & Excel)
Go Analytics is a data analysis and visualization consulting firm specializing in Microsoft Power BI. For any Power BI inquiries, please contact us at https://goanalyticsbi.com/contact.
You can download our template files here: https://goanalyticsbi.com/product/app...
In this video, we show you how to append two or more queries in Power Query. This is a powerful way of combining data from multiple data files that follow the same structure.
Through an example, we show you how to append human resources data from multiple data files that follow the same structure. We also explain what happens when you append queries of different columns.
In the final step, we demonstrate how disable loading the interim queries into our data model so that only the combined dataset gets loaded into Power BI for visualizing.
Hope you enjoy this video and we'll see you in the next one!
For more how-to and tips & tricks videos on Power BI make sure to subscribe to our channel.
About Go Analytics Inc.
We are data analysis and visualization consultants specializing in Power BI. We help organizations create and nurture a data culture.
Need help getting started with Power BI? Let's connect!
Visit our website at https://goanalyticsbi.com
Follow us on Twitter at / goanalyticsinc
Connect with us on LinkedIn at / go-analytics-inc
***
Note: Go Analytics Inc. is not affiliated with Microsoft. Thoughts are our own.