My SQL Connection with fabric without on-premises data gateway

[Anonymous]

Hello,

I have a question about the capabilities of Microsoft Fabric in relation to connecting MySQL to Power BI without the need for a gateway. As I understand, Microsoft Fabric is a technology that aims to integrate different data-related platforms and offer a cohesive experience.

Specifically, I'm interested to know if Microsoft Fabric provides a solution or mechanism to establish a direct connection between MySQL and Power BI, eliminating the requirement for an on-premises gateway. Can Microsoft Fabric facilitate the seamless flow of data from MySQL to Power BI within its integrated framework?

[ibarrau · Accepted solution]

Hi. If you have a MySQL on premise or in another vendoor, then you must use a Gateway (dataflow gen2) or Integration runtime (data factory) in order to read the data as source. You need to install a mysql driver first and then you can use the gateway. For now, there is no cloud provider or something like that to get direct connection like databricks, snowflake or SQL Server.

I hope that helps,