Merge Fields of different tables

[ADC]

Hello Community

I have the same Fields in different Databases in SQL Server.

Example:

  Database: "2017" (with some tables)

  Fields: Id, Date, Customer, Amount (in one of the Tables)

  Database: "2018" (with some tables)

  Fields: Id, Date, Customer, Amount (in one of the Tables)

I would like to know how to import the info in one Database in Power BI, so I can create graphics and tables that can be easily shown or filtered by year.

Thanks in advance for your help.

Regards

PS: The set of Databases, Tables and Fields is rather complex. I use a simplified set here to show my problem.

[Vvelarde]

@ADC

Hi, In Query Editor with Merge Option in the Menu.

Regards

Victor