cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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 PowerBI for data refresh.

 

Is there anyway can I achieve this?

 

Thanks

Jonty

4 REPLIES 4
Helper I
Helper I

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

Super User IV
Super User IV

Are you running into a particular issue when doing this? I can't think of a reason this shouldn't work if you use the Desktop and specify to use database credentials.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi, wanted to follow up and see if this scenario worked for you. If it did, please mark the thread as solved.

 

 

Youssef Shoukry
Product Manager, Power BI

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors