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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors