Forum Discussion

PB_PRO's avatar
PB_PRO
Frequent Visitor
1 year ago
Solved

Datamart SQL Endpoint Certificate Error

Connecting to the sql endpoint  at *.datamart.pbidedicated.windows.net recently has started failing to refresh with the following error. One or more errors occurred.;One or more errors occurred. Th...
Dataflow
General Comment
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    Hi PB_PRO 

     

    The error occurs because the old SQL endpoint (*.datamart.pbidedicated.windows.net) is no longer valid and doesn’t match the SSL certificate. Switching to the new endpoint (*.datamart.fabric.microsoft.com) resolves the issue.

    Key points:

    • The older endpoint is likely deprecated.
    • Microsoft should update their documentation to reflect the new endpoint.
    • Use the new endpoint (*.datamart.fabric.microsoft.com) to avoid the issue.
    •  

    Did I answer your question? Mark my post as a solution, this will help others!

    If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

    Kind Regards,
    Poojara
    Data Analyst | MSBI Developer | Power BI Consultant
    Please Subscribe my YouTube for Beginners/Advance Concepts: Channel Link 

Poojara_D12's avatar
Poojara_D12
Super User
1 year ago

Hi PB_PRO 

 

The error occurs because the old SQL endpoint (*.datamart.pbidedicated.windows.net) is no longer valid and doesn’t match the SSL certificate. Switching to the new endpoint (*.datamart.fabric.microsoft.com) resolves the issue.

Key points:

  • The older endpoint is likely deprecated.
  • Microsoft should update their documentation to reflect the new endpoint.
  • Use the new endpoint (*.datamart.fabric.microsoft.com) to avoid the issue.
  •  

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: Channel Link