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

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
Anonymous
Not applicable

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 @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
Not applicable

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

 

 

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.