Firewall rules required for powerBI server authentication
Hello all, Can someone help to configure the wirewall to be able to isolate powerBI server? We have a problem of not being able to go past the authentication to MS as we are not sure what rules to use to allow it through FW. We have allowed most of urls according to the documentation online but the issue still persists. Perhaps someone could help to summarise what to whitelist? thanks
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/