Forum Discussion
Helper VConnect 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
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
