cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Connect Power BI Dashboard in Service to Mysql DB hosted on Linux Server

Hi there, 

 

Can anyone advise on how to connect a Power BI Dashboard hosted in the Service to a MySQL DB hosted on a remote Linux Server?

 

Are there any solutions that don't involve installing a gateway on a Windows machine?

 

Many Thanks, 

 

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @Anonymous ,

 

if Power BI Service should connect directly to your on premises MySQL database, the only option is a gateway. You don't have to install the gateway on the same server. You can also install it on a Windows VM that would be able to access the data source.

 

But without a gateway you cannot connect to your on premises MySQL DB.

 

Otherwise you have to search for an alternative approach like upload the data from your MySQL DB to a cloud database like an Azure Database for MySQL or Azure SQL Server. Then the Power BI Services can connect to that  cloud database without a gateway.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

1 REPLY 1
selimovd
Super User
Super User

Hey @Anonymous ,

 

if Power BI Service should connect directly to your on premises MySQL database, the only option is a gateway. You don't have to install the gateway on the same server. You can also install it on a Windows VM that would be able to access the data source.

 

But without a gateway you cannot connect to your on premises MySQL DB.

 

Otherwise you have to search for an alternative approach like upload the data from your MySQL DB to a cloud database like an Azure Database for MySQL or Azure SQL Server. Then the Power BI Services can connect to that  cloud database without a gateway.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors