Forum Discussion
Mysql cloud database refresh data
Hi. If you want to connect to mysql you need a data gateway even if it's in cloud. The idea of having a source in cloud is not the only reason for avoiding a data gateway. It dependes on the source if Power Bi will be able to read it. Power Bi Service contains a limited connector to data sources and you can't install it more. If you think about it you have installed a connector for mysql in order to get data from the source with Power Bi Desktop. Power Bi service doesn't have that connecotr on cloud and that's why it needs a gateway to refresh data even if it's in cloud. It can't read that engine by default.
I would recommend a VM in the current cloud vendor to install the on premise data gateway.
Hope this helps,
P/D Don't forget to restart the vm after installing the mysql provider for power bi.
Hi. If you want to connect to mysql you need a data gateway even if it's in cloud. The idea of having a source in cloud is not the only reason for avoiding a data gateway. It dependes on the source if Power Bi will be able to read it. Power Bi Service contains a limited connector to data sources and you can't install it more. If you think about it you have installed a connector for mysql in order to get data from the source with Power Bi Desktop. Power Bi service doesn't have that connecotr on cloud and that's why it needs a gateway to refresh data even if it's in cloud. It can't read that engine by default.
I would recommend a VM in the current cloud vendor to install the on premise data gateway.
Hope this helps,
P/D Don't forget to restart the vm after installing the mysql provider for power bi.
hi, where should this gateway be installed or setup?