cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chrisparks
Frequent Visitor

BUG/Enhancement: PBI Desktop connecting to SQL Server on Docker

I spent half a day trying to figure out why I could connect to my SQL Server Docker container with multiple tools (Aginity Pro, Azure Data Studio, VSCode, sqlcmd), but I could not connect using "localhost:1433" as the server name via PBI Desktop.

 

When you open PBI Desktop and navigate to Get Data > SQL Server, the information icon next to the Server textbox says to use "servername:port" which only ever sent back errors when attempting to connect to my Docker container. I thought something port/tcp setting was incorrect within Docker, but I was finally able to connect using "localhost, 1433" instead of the "servername:port" format. The only reason I ended up being able to connect was from another user mentioning to use "localhost, 1433" as the Server.

 

It would be beneficial for PBI Desktop to either: auto-resolve "localhost:1433" when connecting to a Docker container, or to include all combinations of connection strings inside of the information icon 🙂

1 REPLY 1
v-yuta-msft
Community Support
Community Support

@chrisparks ,

 

I would suggest you create an idea here to help power bi improve.

 

Regards,

Jimmy Tao

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

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!

Top Solution Authors