Forum Discussion
Can I connect MySQL DB from Linux to online reports for data refresh
Hello,
I am facing the similar issue as Jonty's. Our MySQL db is running on a Linux server. At the moment, am running the whole PowerBI suite on my laptop. I managed to connect to the live data via Putty. Data refresh only works if Putty is active. If Putty is inactive, the connection to the live data fails.
I wonder if there is a way that Power BI connects to MySQL db running on a Linux server without having to rely on third party tool like Putty?
Thanks.
Hi,
I am not sure about this. As per comments in this post, power bi service refresh from Linux MySQL DB should be possible.
But I found other posts which says it's not possible.
Requirements to install the on-premise gateway, Windows:
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
As per this idea, looks like it's not possible now:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7020353-mysql-over-ssh-connection
Can anyone confirm if this is possible?
Thanks
