Forum Discussion
edX Lab 7, Exercise 1,: Login Credentials Invalid
The Instructions Below do not work. Cannot Complete course without this completed.
Please help
Exercise 1: Direct Connectivity From Power BI Desktop
- Start with a blank Power BI Desktop file.
- Connect to the Azure SQL database by using Get Data and select the Microsoft Azure SQL database.
- Enter the following information to connect to the SQL Database.
- Server: msedxeus.database.windows.net
- Database: DAT207x01
- Ensure DirectQuery is selected and click OK.
- Select to use Database credentials and enter the following information to login and click Connect.
- Login: PBILogin
- Password: P@ssw0rd
- Select the bi.salesFact the bi.Date tables and click Load.
- Create a chart based on the Card visualization.
- Drag the Revenue field from the bi salesFact table to the chart.
- Create a slicer based on the Slicer visualization.
- 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.
4 Replies
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/7761Regards,
Daniel He
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
for some its because of the following instruction makesure you have seleceted Database
- Select to use Database credentials and enter the following information to login and click Connect.
