Solved: Re: Connecting PowerBI and MySQL

albertanthony · ‎08-02-2023

I have a PowerBI installed on my work laptop, but have MySQL server accessed through Remote Desktop, and I also have a PowerBI installed on my Remote Desktop. Is it possible to pull directly MySQL data from my laptop's PowerBI (without accessing Remote Desktop)? I know this can be done if i use the Remote Desktop's PowerBI, however, it's quite laggy. Anyone got insights on this? Thanks before!

Anonymous · ‎08-03-2023

HI @albertanthony,

Power bi desktop can get data from remote data sources, You should be configured on your database and firewall setting to allow these reuqest can be accessed from the device installed power bi desktop client.

If can't directly accessed, you may need to install the proxy/VPN on your device to mapping network to help desktop client to connect to the remote database.

Regards,

Xiaoxin Sheng

View solution in original post

Anonymous · ‎08-03-2023

HI @albertanthony,

Power bi desktop can get data from remote data sources, You should be configured on your database and firewall setting to allow these reuqest can be accessed from the device installed power bi desktop client.

If can't directly accessed, you may need to install the proxy/VPN on your device to mapping network to help desktop client to connect to the remote database.

Regards,

Xiaoxin Sheng