Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using Azure Database for MySQL with the following configuration as the data source on a PowerBI report
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/
"I do not have any gateways configured given that the database is on Azure"
Yeah, that would be too logical. If you have a Pro license you can raise a ticket with Microsoft and ask them why this requires a gateway.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |