I am currently in my company's test envionrment trying to connect my BI solution to the SQL server via On-Premise Personal Gateway. When I am in Power BI service and click "edit credentials" for the SQL connection, I get this message:
Failed to update data source credentials: Cannot open server 'dev-lab-123' requested by the login. Client with IP address 'xxx_xxx_xxx_xx' is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect
I was able to connect to the SQL server just fine in SSMS when looking at the SQL view I connected to. When I type in the same user name and password I did in SSMS its giving me this message. If anyone has any idea how to fix this issue, please do let me know.