Forum Discussion
Helper VConnect PBI desktop to local Microsoft sql server on same device?
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/
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
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 🙂
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
