Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 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

Data Protection
Tips and Tricks

2 Replies

  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    Continued Contributor
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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