Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I need to connect Power Query Online to MySQL without a gateway on premise; but when I tried to do this the gateway field is requiered as obligatory but in the docs it says "if necesary..."
Is there a way to do it without completing this field?
Power Query MySQL database connector | Microsoft Docs
Solved! Go to Solution.
Hi MySQL as the a onpremies datasources requires gateway. The sources that doesn't require gateway are online databases such as Azure SQL DB, Azure SQL Data Warehouse, Azure Analysis Services and Spark on Azure HDInsight.
Paul Zheng _ Community Support Team
Hi MySQL as the a onpremies datasources requires gateway. The sources that doesn't require gateway are online databases such as Azure SQL DB, Azure SQL Data Warehouse, Azure Analysis Services and Spark on Azure HDInsight.
Paul Zheng _ Community Support Team
Thank... 😣
@jorgeandreoni Do you know if your MySQL database is accessible from the Azure cloud? If it isn't then you need the gateway.