PowerBI (using direct querywith Sql Server Service Account not working.Getting authentication error.

[Satya_Machari]

Hi All,

PowerBI (using direct querywith Sql Server Service Account not working.Getting authentication error.

Please suggest if any idea.

Thanks

satya

[v-rzhou-msft · Accepted solution]

Hi @Satya_Machari ,

Try this way in SQL Server:

File->Options and Settings -> Data Source Settings, choose your SQL Server data source and select Edit and uncheck "Encrypt Connections" option.

For reference:

Login Error while connecting SQL Database through Power BI?

Data Source Authentication error in Power BI Server

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

please provide more details and context.