Reply
Frequent Visitor
Posts: 3
Registered: ‎03-19-2017

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

Hello 

I am experiencing the same problem. Both solutions suggested earlier don't seem to work for me

  1. I have no idea how to log in to azure. Should I create a free azure account and use the steps lined out in https://docs.microsoft.com/en-us/azure/sql-database/sql-database-configure-firewall-settings? Or is this something that the sys admin in my work domain should do?

  2. When I try to connect to the Azure SQL Database from the webversion, I get a notification directing me back to the desktop version.

 

I would hate to see me fail on this course because of this technical issue. Any other workaround to finish the lab exercise would be greatly appreciated.

 

Thanks

 


ps. Here is the message the webversion tells me when I try to connect.
azure.jpg

Member
Posts: 138
Registered: ‎03-10-2016

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

I think you should use Power BI Service to connect the Azure SQL Database, the course lab7 exericse document was updated, you can use Power BI Desktop to connect Azure SQL Database.

Highlighted
Frequent Visitor
Posts: 3
Registered: ‎03-19-2017

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

Indeed I was following the course info, but as I am struggling for hours with KB articles without any effect, I am looking for alternative ways to finish the lab 7 excercise. Does anyone have a workaround for this problem?

 

Thanks

Frans

Member
Posts: 138
Registered: ‎03-10-2016

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

The Power BI Service have updated before, It will not support to connect Azure SQL Server Database, so now, if you need to connect SQL Server Database, you only use Power BI Desktop.  

Frequent Visitor
Posts: 7
Registered: ‎05-17-2017

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

Hi 

 

I am getting the exact same message while connecting to Azure SQL Database from Power BI Desktop. I don't hav access to Azure Portal . So I cann't set the rules to accept my IP address. I don't see any instructor's email from whom I can get help. Does anyone have instructor's email ? Some threads here said to contact the instructor . So I am seeing if they can help....

 

Thanks

 

 

Member
Posts: 48
Registered: ‎03-10-2016

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

Hi, can you please try again? I faile to connect databases at first and got the same error, I chose edit and clicked connect, it worked this time.

Capture.PNG

Frequent Visitor
Posts: 2
Registered: ‎05-25-2017

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

This doesn't work for me....How can we complete the lab 7 then?

Frequent Visitor
Posts: 2
Registered: ‎05-25-2017

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

I think I met the same issue with you. Have you got the solution?

Frequent Visitor
Posts: 3
Registered: ‎03-19-2017

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

Hello

I did manage to get it working using the Power BI Desktop. I used another system to make the connection and then it worked. I am unsure of the exact reason why it was not working. Sorry that I cannot be more specific.

Good luck

Frans