Setting up initial Azure SQL DB connection in Power BI Desktop

[Anonymous]

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.

[Icey]

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

[Anonymous · Accepted solution]

Ok, bloody idiot here.   Found my solution:  

Needed to go into PowerBI datasource options and change in place