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

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.