Can we get data from multiple MySQL servers with multiple credential into PowerBI Desktop

[Anonymous]

Can we get data from multiple MySQL servers with multiple credentials into PowerBI Desktop and Append them?

Suppose I have two locations LocA and LocB
SERV1 is for LocA with credentials user1 and password1 have table1
and
SERV2 is for Loc B with credentials user2 and password2 have table 1

I want to get data from both servers and append table 1 and prepare my common report for all

[Dinesh_Suranga]

@Anonymous 

Hi,

You have to create two queries. one for SERV1 DB and the other one for SERV2 DB.

Then make sure the table column headers are simmiler in two table.

Then you can append two tables to a new table.

Or you can append one table to another.

Thank you.

[Anonymous]

Yes, I am sure there are similar tables. I  fetched the data and appended it also but after clicking on close and applying it in the power query editor it asks for credentials again and again repeatedly from both servers.
And there are not only two servers there are 46 servers and their multiple credentials as well