Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

My SQL Connection with fabric without on-premises data gateway

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...
Need Help
  • ibarrau's avatar
    ibarrau
    3 years ago

    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,

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
3 years ago

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,