Forum Discussion
Can we get data from multiple MySQL servers with multiple credential into PowerBI Desktop
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...
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.
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