Forum Discussion

gang123's avatar
gang123
Regular Visitor
6 months ago
Solved

PowerBI to MySQL without gateway

Hi all,   I built a PowerBI dashboard that connects to a MySQL database. Currently this connection requires an on-prem gateway to schedule refresh in the service. I was wondering if it's possible t...
Need Help
  • Cookistador's avatar
    Cookistador
    6 months ago

    Hi gang123 

     

    Indeed, with a Azure database  for Mysql, you need a gateway

     

    I see two solutions to fix this issue

     

    1) Install your gateway on a virtual machine on azure, with a schedule to start and stop it when you need to use it to refresh your dataset

    2) Migrate the data from mysql database to a sql server managed instance 

     

    Do not hesistate to ask if you need more help

Cookistador's avatar
Cookistador
Super User
6 months ago

Hi gang123 

 

Indeed, with a Azure database  for Mysql, you need a gateway

 

I see two solutions to fix this issue

 

1) Install your gateway on a virtual machine on azure, with a schedule to start and stop it when you need to use it to refresh your dataset

2) Migrate the data from mysql database to a sql server managed instance 

 

Do not hesistate to ask if you need more help

gang123's avatar
gang123
Regular Visitor
6 months ago

What is the best way to migrate the database?