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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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!:
The Definitive Guide to Power Query (M)

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors