Blog Post

Power BI Community Blog
8 MIN READ

Combine multiple tables with UNION / UNION ALL in SQL Server, APPEND in Power Query or UNION in DAX

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago
If you want to combine several tables, you have to ask yourself whether you should do this already in the data source such as SQL Server, in the processing of the data (ETL) in Power Query or in Powe...
Updated 5 years ago
Version 2.0
how to
roundup
selimovd's avatar
Icon for Most Valuable Professional rankMost Valuable Professional
Joined November 09, 2015
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
akee's avatar
akee
Icon for Helper I rankHelper I
4 years ago

this answer is another example of how DAX may have some advantages, but are difficult to understand when compared to how extremely simple it would be to achieve a more flexible union query using the SQL view in MS Access.