The credentials provided for the sql source are invalid - Azure SQL Mirror

Hi JAnder ,

Thank you for reaching out to Microsoft Fabric Community Forum.

JAnder , Azure SQL Mirror issue, where refreshes fail once every few weeks with a “credentials invalid” error and then work again after a manual refresh, is almost certainly caused by an authentication problem rather than SQL permissions. The most common reason is that the service principal is using a client secret that expires periodically, or the gateway is holding an old Azure AD token in its connection pool, which becomes invalid after some time. When the token or secret expires, all report refreshes fail until the gateway resets or new credentials are provided. The fix is to check and rotate the service principal secret, re-enter credentials in the gateway, or restart the gateway to clear expired tokens. For long term stability, use certificates or managed identities instead of short life secrets and set up alerts for expiring credentials.
If this doesn't fix the issue, please share a screenshot of the error message so we can work on a solution based on that.

Regards,
B Manikanteswara Reddy