Multiple database Query

[Mohd_ilyas]

If I have Three different system and three different databases how can I Import data into power bi and if I have two tables for eg: USAtable from system 1 and the other one is UKtable from system 2  and both table have same customer details and I want to get outstanding balance by calculating data from system 1 and system 2 ?

[mahoneypat]

If you have tables with the same columns, you can just append them in the query editor (perhaps adding a custom column on each first with the same column name to identify the source).  You can then disable load on the source table and only load the appended tables.

For multiple databases, if you are making the same query to each, you can make a function that takes the database name as an input parameter.  You can then make a small table of the database names and then invoke that custom function using the name column as the input parameter.

Pat