I am using Azure Database for MySQL with the following configuration as the data source on a PowerBI report
- Firewall Rules: Allow access to Azure services
- SSL Settings: Enforce SSL connection is set to disabled
PowerBI Desktop is able to connect to the database.
I then publish the report. Go to app.powerbi.com/home and refresh the dataset.
I get the error Refresh failed due to gateway configuration issues
I do not have any gateways configured given that the database is on Azure
Any tips/guidance would be appreciated.
Some details from the error message and connection to db
Refresh failed due to gateway configuration issues.
This dataset requires a properly configured gateway in order to refresh.If you're using personal mode, please make sure your gateway is online.If you're using enterprise mode, please make sure you've added the following data sources in the Gateway Management PortalMySql { server : "XYZ.mysql.database.azure.com" , database : "SOMEDB" }
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 5a23474e-1edc-47a3-9dc7-6754c7573879
Request ID: 6d6a2546-9b32-4a8a-31eb-cdf61d91e877
Correlation ID: 02f417aa-bb63-fccf-8064-353a8c646a83
Time: Wed Oct 14 2020 17:10:30 GMT-0700 (Pacific Daylight Time)
Service version: 13.0.14437.75
Client version: 2009.4.03166-train
Cluster URI: https://wabi-us-north-central-redirect.analysis.windows.net/
