edX Lab 7, Exercise 1,: Login Credentials Invalid

[Anonymous]

The Instructions Below do not work. Cannot Complete course without this completed. 

Please help

 

 

Exercise 1: Direct Connectivity From Power BI Desktop

1. Start with a blank Power BI Desktop file.
2. Connect to the Azure SQL database by using Get Data and select the Microsoft Azure SQL database.
3. Enter the following information to connect to the SQL Database.
• Server: msedxeus.database.windows.net
• Database: DAT207x01
4. Ensure DirectQuery is selected and click OK.
5. Select to use Database credentials and enter the following information to login and click Connect.
• Login: PBILogin
• Password: P@ssw0rd
6. Select the bi.salesFact the bi.Date tables and click Load.
7. Create a chart based on the Card visualization.
8. Drag the Revenue field from the bi salesFact table to the chart.
9. Create a slicer based on the Slicer visualization.
10. Drag the Year field from the bi Date table to the slicer.

IMPORTANT! If you cannot login, please try the following:

• The data import may take a while depending on the speed of your Internet provider.
• Ensure you are not behind a firewall. 
• Try typing the server details and credentials instead of copy pasting.

[Justice_Goto]

for some its because of the following instruction makesure you have seleceted Database

1. Select to use Database credentials and enter the following information to login and click Connect.

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[Anonymous]

[v-danhe-msft]

Hi @Anonymous,

I suggest you to check the server name to make sure your input correct server name. You can also try to connect SQL Azure via SSMS. If it also fails, please check the Azure firewall configuration by refering to this link: 
https://community.powerbi.com/t5/Desktop/Can-t-connect-to-Azure-Database/td-p/7761

Regards,

Daniel He