how unify data of two same databases?

[jerohan]

I have  4 databases, with the same structure (fields, etc) but distinct data:

(2 databases in the image).

How i unify this data in the same report ( for example sum data of any field)?

In the Page of reporte i only show the data of database 1 (source 1).

Any idea?.

[Anonymous · Accepted solution]

Merge the tables into one in Power Query

[Anonymous · Accepted solution]

Merge the tables into one in Power Query

[jerohan]

Thank's. But , how i do it?

[ssugar · Accepted solution]

In the Query Editor, go to Home tab > Merge Queries