Forum Discussion

stilllearningbi's avatar
stilllearningbi
Frequent Visitor
3 years ago

IP Address is blocked between Power BI and SQL Server connection

  I've been encountering this issue for several days. This error keep coming only when I'm working from home and connected to my home wifi. But when I use wifi at the office/my renta...
Need Help
Shahfaisal's avatar
Shahfaisal
Solution Sage
3 years ago

Looks like it is happening due to IP changes. The best advice I have is to connect to your office VPN first and then login to the database. Since your office network is configied to be allowed to connect to the database, it should work.

stilllearningbi's avatar
stilllearningbi
Frequent Visitor
3 years ago

I have connect to my company vpn but the issue still persists. Is it because of my Azure account?

  • Shahfaisal's avatar
    Shahfaisal
    Solution Sage
    3 years ago
    stilllearningbi wrote:

    I have connect to my company vpn but the issue still persists. Is it because of my Azure account?

    I don't think the issue is with your Azure account. The issue is your IP address is blocked by the Azure firewall. I would do the following:

    1. Get your IP address. https://www.ipchicken.com/

    2. Work with your Azure admin to find out if your IP range is allowed.

    3. Based on the outcome from #2, work with your infrastructure/Azure admin to get your IP permitted through Azure firewall.