Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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
| User | Count |
|---|---|
| 57 | |
| 44 | |
| 32 | |
| 16 | |
| 14 |
| User | Count |
|---|---|
| 84 | |
| 70 | |
| 38 | |
| 27 | |
| 24 |