Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Connect PowerBI to SQL Server - TrustServerCertificate

Hi there,   I have a problem with connecting my PowerBI desktop to my SQL server. I know 100% the problem lies with the 'TrustServerCertificate' attribute.   When logging into to SSMS, or creatin...
Data Protection
Need Help
tralala2's avatar
tralala2
New Member
1 year ago

Hello! I have the same issue as the OP. I tried going to Control Panel, Edit Environmnet Variables, as Johag mentioned. It didn't work, I still cannot open my SQL Server tables in PBI. Where did you input this code, JMLyle ? 

tralala2's avatar
tralala2
New Member
1 year ago

NEVERMIND, it worked. It just needed a Restart before trying again. So use the method written by the 2 users above, but restart your computer before retrying!

🍻