Forum Discussion

Sandeep_1007's avatar
Sandeep_1007
Regular Visitor
3 months ago
Solved

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, ...
Need Help
  • oussamahaimoud's avatar
    oussamahaimoud
    3 months ago

    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 🙂 

oussamahaimoud's avatar
oussamahaimoud
Memorable Member
3 months ago

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 🙂