Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.