Forum Discussion
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 it possible? I'm not getting it... The mdb Item table now appears as xpto. Item... Thank you.
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.
4 Replies
- lbendlin
Super User
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
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.
