Forum Discussion

vips's avatar
vips
Frequent Visitor
5 years ago

Refresh failed due to gateway configuration issues

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/

1 Reply

  • "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.