cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Lab 7 Exercise 1 - Can't connect to the Azure SQL Database

Hi,

 

For some reason, when I try and connect to the Azure SQL database for lab 7 I get the following error (please see screenshot below):

 

Anyone have any suggestions on how I can resolve this?

 

Thanks,

Ikenna

 

Capture.PNG

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Lab 7 Exercise 1 - Can't connect to the Azure SQL Database

I think I was being blocked by my work VPN

View solution in original post

18 REPLIES 18
Highlighted
New Member

Re: Lab 7 Exercise 1 - Can't connect to the Azure SQL Database

I also got this error around 10:00 am EST and tried all the other responses and solutions and could not get it to work. Any help would be appreciated. Thank you

Highlighted
Helper I
Helper I

Re: Lab 7 Exercise 1 - Can't connect to the Azure SQL Database

This could be because of azure firewall issue. In allowed IP addresses section get your external ip address added.This should solve ypur problem as it solved mine.

Highlighted
New Member

Re: Lab 7 Exercise 1 - Can't connect to the Azure SQL Database

Hello SaritaSenapati,

May you please let me know the proper steps to take to make sure I properly update the issue with firewall. Sorry it does not seem to be my side and I am not sure what steps to follow. Thank you

Highlighted
Helper I
Helper I

Re: Lab 7 Exercise 1 - Can't connect to the Azure SQL Database

Steps to follow:

 

1) Google whats my IP. Search result will show you your External IP address.

2) Add your external ip address in azure by following the steps given in the below link:

 

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-configure-firewall-settings

 

3) Open powerBI desktop -> click on  get data->select azure->select microsoft azure sql database->enter server name -> click on import-> on your left you get two options windows and database-> click on database -> enter credentials -> click connect.

 

And if still doesnt work, then use power BI service(Power BI web version) to connect to the azure sql database.

 

 

Sarita

 

 

Highlighted
Post Patron
Post Patron

Re: Lab 7 Exercise 1 - Can't connect to the Azure SQL Database

Sometimes, I also have same issue with you. But I click Retry button, it is worked for me, you can try it more time

Highlighted
New Member

Re: Lab 7 Exercise 1 - Can't connect to the Azure SQL Database

Sarita, I have the same problem, but i cant access to azure portal because i dont have account in it, it is an issue to solve by the course teachers? Please help me to change the firewall.

Highlighted
Helper I
Helper I

Re: Lab 7 Exercise 1 - Can't connect to the Azure SQL Database

@lgarcia Hi, If you do not have access to the azure portal, you cant change the firewall settings. Try below two options and if you still face connection issues then contact your course teacher.

 

Option 1: Open powerBI desktop -> click on  get data->select azure->select microsoft azure sql database->enter server name -> click on import-> on your left you get two options windows and database-> click on database -> enter credentials -> click connect.

 

Option 2: use power BI service(Power BI web version) to connect to the azure sql database.

 

Regards,

Sarita

 

Highlighted
Frequent Visitor

Re: Lab 7 Exercise 1 - Can't connect to the Azure SQL Database

I think I was being blocked by my work VPN

View solution in original post

Highlighted
Post Patron
Post Patron

Re: Lab 7 Exercise 1 - Can't connect to the Azure SQL Database

Very sorry, we still not repro the issue, I think you need to uninstall and reinstall Power BI, you can use latest version to try it

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021