cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
boriosdog
New Member

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.

boriosdog_3-1612465565427.png

 

 

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

 

boriosdog_2-1612465444409.png

 

boriosdog_1-1612465403028.png

 

boriosdog_0-1612465318077.png

 

 

Any help will be greatly appreciated.

1 ACCEPTED SOLUTION
boriosdog
New Member

Ok, bloody idiot here.   Found my solution:  

 

Needed to go into PowerBI datasource options and change in place

boriosdog_0-1612466028740.pngboriosdog_1-1612466080019.png

 

 

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

Hi @boriosdog ,

 

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

boriosdog
New Member

Ok, bloody idiot here.   Found my solution:  

 

Needed to go into PowerBI datasource options and change in place

boriosdog_0-1612466028740.pngboriosdog_1-1612466080019.png

 

 

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors