Forum Discussion
Facing issue while scheduled refreshing semantic model
Hi all, has anyone experienced this issue or noticed anything unusual with the scheduled refresh? It isn't working for me either.
I also want to mention that manual refresh attempts aren't working, which makes it difficult to keep the reports updated.
Hi Sandeep_1007,
This is a classic SQL Server SSL/TLS certificate error that occurs when the Gateway or the connecting machine does not trust the certificate presented by the SQL Server.
Add TrustServerCertificate=True in the connection string
In your Gateway data source settings (Power BI Service → Manage Gateways), edit the data source and add to the connection string:
TrustServerCertificate=True
Use this in trusted internal environments only👌
Hope this helps! Don't forget to ask for more information. Don't forget to mark as solution and thumbs up in order to keep helping 🙂
4 Replies
Hi Sandeep_1007,
This is a classic SQL Server SSL/TLS certificate error that occurs when the Gateway or the connecting machine does not trust the certificate presented by the SQL Server.
Add TrustServerCertificate=True in the connection string
In your Gateway data source settings (Power BI Service → Manage Gateways), edit the data source and add to the connection string:
TrustServerCertificate=True
Use this in trusted internal environments only👌
Hope this helps! Don't forget to ask for more information. Don't forget to mark as solution and thumbs up in order to keep helping 🙂
Hi Sandeep_1007,
I would also take a moment to thank oussamahaimoud , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Regards,
Community Support Team.Hi Sandeep_1007,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Community Support Team.
