Change mdb source to mysql

[tavaresada]

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 it possible? I'm not getting it... The mdb Item table now appears as xpto. Item... Thank you.

[Anonymous · Accepted solution]

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]

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

Hi @lbendlin ,

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

Best Regards,

Neeko Tang

[lbendlin]

Do you need help to remove the table name from the column names?  That's something you can do in Power Query via Table.TransformColumnNames - PowerQuery M | Microsoft Learn