Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

  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.
4 REPLIES 4
Justice_Goto
Frequent Visitor

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
Employee
Employee

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Capture.PNG

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.