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 🙂 

v-hjannapu's avatar
v-hjannapu
Community Support
3 months ago

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.

v-hjannapu's avatar
v-hjannapu
Community Support
2 months ago

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.