Forum Discussion

jontymate's avatar
jontymate
Frequent Visitor
10 years ago

Can I connect MySQL DB from Linux to online reports for data refresh

Hi   I was able to use PowerBI gateway to connect my local test MySQL DB from Windows to online reports for data refresh. But the thing is I want to connect my live MySQL DB from Linux to online P...
KTP_UBS's avatar
KTP_UBS
Helper I
10 years ago

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.

 

 

aarola's avatar
aarola
Frequent Visitor
8 years ago

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