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

[Anonymous]

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, 

[selimovd · Accepted solution]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic