Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Setting up initial Azure SQL DB connection in Power BI Desktop

Hi all, 

I'm trying ot setup the intial connection to an Azure SQL DB instance in Power BI desktop and it is not asking for credentials.  It seems to assume I want to use default.  I want to utizlie the SQL authentication method that works fine for me via MS SQL Mangement Studio.

 

 

Probably missing something obvious, but can't find the issue yet.  Screenshots of PowerBI attempts below:

 

 

 

 

 

Any help will be greatly appreciated.

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Ok, bloody idiot here.   Found my solution:  

     

    Needed to go into PowerBI datasource options and change in place

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Ok, bloody idiot here.   Found my solution:  

     

    Needed to go into PowerBI datasource options and change in place

     

     

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Glad to hear the issue has been solved. Please accept your reply as a solution so that people who may have the same question can get the solution directly. Your contribution is highly appreciated.

     

     

    Best Regards,

    Icey