Importing 2 SQL tables into one query

Question

I am importing two tables from SQL to PowerBI. One table shows 2020 financial data and the other showing for the past 10 years. Is there a way to combine these into one query in PowerBI. The rows/headers are identical the only thing being different is the amount column.&nbsp;&nbsp;

gpiero · Answer

aishak12&nbsp;Hi,I would try Append in Query Editor. It should work&nbsp;

askspepsi · Answer

hi&nbsp;aishak12&nbsp;;&nbsp;Try Merge or Append option,&nbsp;https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data#:~:text=There%20are%20two%20primary%20ways,query%2C%20you%20append%20the%20query.

anonymous · Answer

Hi&nbsp;aishak12&nbsp;,Could you please provide some sample data in these two SQL tables and your desired result?&nbsp;Are these two tables the same structure?Best RegardsRena

Forum Discussion

Importing 2 SQL tables into one query

3 Replies

Related content

Dynamic M query parameter binding to a query table which uses import mode

Import tables with SQL Query

Replace import table with direct query table

Import all PDF and tables within Power Query

Direct Query or Import