data connection from several databases same model same SQL

[dida]

hi
I want to get data from SQL, the problem is that in this SQL there are several databases
each for different company
the tables and model in each database in the same SQL host is exactly the same
I do not need one data base but several all together
finally I wish to create dashboard and reports from all databases in a way that I can slice the company=database or get aggregation from all the company=database together.
for now I build everything on on one data the duplicate it and change the database name but i get seperate files for each database which is not what I want....
HELP!

 

[sandy666]

try to use PowerQuery aka Get&Transform