Connection to datamart broken

The error you’re seeing typically occurs due to SSL/TLS handshake issues between your client (Excel or Power BI) and the datamart server. Here are some steps to troubleshoot:

1. Verify Credentials: Double-check that your Microsoft account has permission to access the datamart.

2. Check Network and Firewall: Ensure no firewall or network security rule is blocking the connection.

3. Update Excel and Drivers: Make sure Excel, Power BI, and SQL Server drivers are up-to-date, as updates often fix SSL issues.

4. Connection String: Confirm that the SQL connection string is correctly formatted and hasn't changed.

5. SSL/TLS Settings: Check if your organization has updated security protocols that could affect SSL/TLS versions.

If the issue persists, reach out to your IT team or Microsoft support for further assistance, as server-side configuration changes may be required.