Forum Discussion
shaht
Helper I
Helper IPowerBi DirectQuery + SQL Data Connection Issue
I am working on a Live Dashboard using DirectQuery in PowerBI. I am using datasource from SQL Server which updates every 15 minutes. The dashboard is working fine on my PowerBi Desktop, but on ...
v-janeyg-msft It is solved now. The encryption was to be enabled on the SQL Server side – As our server is internal-only we hadn’t enabled encryption on the connection.
v-janeyg-msft
Community Support
Community Support
Actually the 'Encryption' option you mentioned, I never noticed it, this step on the desktop is not important. Of course, it would be great if just ticking this option would solve the issue.
I still think it is because the service is not configured properly, you should always unify the credentials in the desktop and service.
Manage your data source - SQL - Power BI | Microsoft Docs
Janey
shahtHelper I
Helper Iv-janeyg-msft It is solved now. The encryption was to be enabled on the SQL Server side – As our server is internal-only we hadn’t enabled encryption on the connection.