This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
I am trying to connect to Azure databse for MySQL Server but getting below error:
My Approach was:
->Get Data
->Azure SQL Database
-><server name>:3306
I am able to connect to this server using MySQL Workbench.
Additional Info:
Power BI Version: 2.74.5619.621 64-bit (October 2019)
MySQL Connector NET 8,0,16
TIA!
Hi @gcp_kumar ,
Could you please clear the permission of your data source to check again?
Cleared Permission and tried to connect, still getting the same error.
Maybe because of VPN:
Otherwise you can try using a different SQL client which might resolve this issue.
I am not using any VPN. Its strange that I am able to connect to Azure for MySQL using Workbench but not using PowerBI
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 27 | |
| 21 | |
| 21 | |
| 20 | |
| 20 |