Forum Discussion

Icon for Helper V rank

Helper V

5 years ago

Solved

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 ma...

amitchandak
5 years ago
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/
MiraAciu
5 years ago
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

Icon for Super User rank

Super User

5 years ago

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/

Related content