Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
jontymate
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
KTP_UBS
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

Greg_Deckler
Super User
Super User

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors