Forum Discussion

tavaresada's avatar
tavaresada
New Member
2 years ago
Solved

Change mdb source to mysql

Hello! I have a job done in power bi that connects to an access database (mdb). Now I've converted the database to MySql and I want to change the power bi connection to access that new database. Is i...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi tavaresada ,

     

    Yes, it is possible to change the Power BI connection to the new MySQL database. Here are the steps you can follow:

    1. Open the Power BI desktop app and open the report that connects to the Access database.

    2. Click on "Transform data"->Click on "Advanced Editor"->Copy and paste the source.

    3. Open the Power BI desktop app and open the report that connects to the MySQL database.

    4. Repeat step 2 and then replace the source's code in the first report.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi tavaresada ,

 

Yes, it is possible to change the Power BI connection to the new MySQL database. Here are the steps you can follow:

1. Open the Power BI desktop app and open the report that connects to the Access database.

2. Click on "Transform data"->Click on "Advanced Editor"->Copy and paste the source.

3. Open the Power BI desktop app and open the report that connects to the MySQL database.

4. Repeat step 2 and then replace the source's code in the first report.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Anonymous "Change Data Source"  can only change the server/database or file name.  You cannot use that dialog to change from Access to MySQL (for example)

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi lbendlin ,

     

    You're right, thanks for the heads up, I've revised my reply.

     

    Best Regards,

    Neeko Tang