cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
h4tt3n
Resolver I
Resolver I

Connect PBI desktop to local Microsoft sql server on same device?

Hello fellow developers,

 

I want to test a report against a local Microsoft SQL server (2019) that is installed and populated with test data on my local machine. I have no problem accessing and manipulating the database through SSMS, but I can't log into the db through PBI. What am I missing?

 

Help and advice is much appreciated.

 

Thanks in advance, Mike

2 ACCEPTED SOLUTIONS
amitchandak
Super User IV
Super User IV

@h4tt3n , how are you trying that . I was able to connect with machine name and localhost both

refer: https://youtu.be/My0bLn9voo4?list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA&t=108

 

or refer

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

https://hevodata.com/learn/connect-sql-server-to-power-bi/

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

It seems you have encrypted connection enabled. 

Pls check this article 

https://docs.microsoft.com/en-us/troubleshoot/sql/connect/error-message-when-you-connect

 

 

View solution in original post

5 REPLIES 5
MiraAciu
Regular Visitor

Hi Mike,

 

I presume you are using Windows auth on both systems as they are local. 

SSMS is a 32 bit app, Power BI Desktop can be installed on 32 or 64 bit. Check on SQL Server 2019 Configuration Manager if Shared Memory is enabled for both 32 and 64 aplications(SQL Native client configuration -> client protocols). To be sure enable all protocols.

Or, maybe, is better to post the error message here 🙂

@MiraAciu I get the following error:

h4tt3n_0-1611056355015.png

 

It seems you have encrypted connection enabled. 

Pls check this article 

https://docs.microsoft.com/en-us/troubleshoot/sql/connect/error-message-when-you-connect

 

 

View solution in original post

amitchandak
Super User IV
Super User IV

@h4tt3n , how are you trying that . I was able to connect with machine name and localhost both

refer: https://youtu.be/My0bLn9voo4?list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA&t=108

 

or refer

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

https://hevodata.com/learn/connect-sql-server-to-power-bi/

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Thanks, you both were very helpful.

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors