03-19-2017 10:46 PM
I am experiencing the same problem. Both solutions suggested earlier don't seem to work for me
- 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?
- 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.
ps. Here is the message the webversion tells me when I try to connect.
03-19-2017 11:48 PM
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.
03-20-2017 01:46 AM
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?
03-20-2017 11:34 PM
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.
06-09-2017 10:41 AM
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....
06-14-2017 01:22 AM
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.
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.