https://community.fabric.microsoft.com/t5/Developer/Tabular-Editor-Union-tables/m-p/2172347#M32745 <P>Hi&nbsp;@Anonymous</a>&nbsp;,</P> <P>Could you consider connecting to the corresponding data source and importing the corresponding tables into Power BI. Then refer to the following blogs to combine the tables?<BR />1. Use DAX</P> <P><A href="https://carldesouza.com/power-bi-union-dax/" target="_self"><STRONG>POWER BI – UNION IN DAX</STRONG></A></P> <P><A href="https://www.youtube.com/watch?v=1q1OzkQpKfQ" target="_self"><STRONG>Union in Power BI | union in DAX | append tables using dax</STRONG></A></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="yingyinr_0-1636019838611.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/625377i6333663F71A0EB19/image-size/medium?v=v2&amp;px=400" role="button" title="yingyinr_0-1636019838611.png" alt="yingyinr_0-1636019838611.png" /></span></P> <P>2. Handle it in Power Query</P> <P><A href="https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data#combine-queries" target="_self"><STRONG>Combine queries</STRONG></A></P> <P><A href="https://community.powerbi.com/t5/Community-Blog/Combine-multiple-tables-with-UNION-UNION-ALL-in-SQL-Server/ba-p/1696694" target="_self"><STRONG>Combine multiple tables with UNION / UNION ALL in SQL Server, APPEND in Power Query or UNION in DAX</STRONG></A></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="yingyinr_1-1636019946281.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/625378i5EFD6AA55D6A2717/image-size/large?v=v2&amp;px=999" role="button" title="yingyinr_1-1636019946281.png" alt="yingyinr_1-1636019946281.png" /></span></P> <P>Best Regards</P> Thu, 04 Nov 2021 09:59:19 GMT Anonymous 2021-11-04T09:59:19Z https://community.fabric.microsoft.com/t5/Developer/Tabular-Editor-Union-tables/m-p/2166059#M32697 <P>Hi,</P><P>&nbsp;</P><P>I have imported two tables, how can I combine them in the model using Tabular Editor?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="bareanders84_0-1635763649526.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/623222iB9FC6B9C639D8698/image-size/medium?v=v2&amp;px=400" role="button" title="bareanders84_0-1635763649526.png" alt="bareanders84_0-1635763649526.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>Regards,</P><P>Anders</P> Mon, 01 Nov 2021 12:05:58 GMT https://community.fabric.microsoft.com/t5/Developer/Tabular-Editor-Union-tables/m-p/2166059#M32697 Anonymous 2021-11-01T12:05:58Z https://community.fabric.microsoft.com/t5/Developer/Tabular-Editor-Union-tables/m-p/2172347#M32745 <P>Hi&nbsp;@Anonymous</a>&nbsp;,</P> <P>Could you consider connecting to the corresponding data source and importing the corresponding tables into Power BI. Then refer to the following blogs to combine the tables?<BR />1. Use DAX</P> <P><A href="https://carldesouza.com/power-bi-union-dax/" target="_self"><STRONG>POWER BI – UNION IN DAX</STRONG></A></P> <P><A href="https://www.youtube.com/watch?v=1q1OzkQpKfQ" target="_self"><STRONG>Union in Power BI | union in DAX | append tables using dax</STRONG></A></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="yingyinr_0-1636019838611.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/625377i6333663F71A0EB19/image-size/medium?v=v2&amp;px=400" role="button" title="yingyinr_0-1636019838611.png" alt="yingyinr_0-1636019838611.png" /></span></P> <P>2. Handle it in Power Query</P> <P><A href="https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data#combine-queries" target="_self"><STRONG>Combine queries</STRONG></A></P> <P><A href="https://community.powerbi.com/t5/Community-Blog/Combine-multiple-tables-with-UNION-UNION-ALL-in-SQL-Server/ba-p/1696694" target="_self"><STRONG>Combine multiple tables with UNION / UNION ALL in SQL Server, APPEND in Power Query or UNION in DAX</STRONG></A></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="yingyinr_1-1636019946281.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/625378i5EFD6AA55D6A2717/image-size/large?v=v2&amp;px=999" role="button" title="yingyinr_1-1636019946281.png" alt="yingyinr_1-1636019946281.png" /></span></P> <P>Best Regards</P> Thu, 04 Nov 2021 09:59:19 GMT https://community.fabric.microsoft.com/t5/Developer/Tabular-Editor-Union-tables/m-p/2172347#M32745 Anonymous 2021-11-04T09:59:19Z