Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
PowerBI (using direct querywith Sql Server Service Account not working.Getting authentication error.
Please suggest if any idea.
Thanks
satya
Solved! Go to 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.
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.
please provide more details and context.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |