Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Connection to Microsoft Fabric Data Warehouse changes from Service Principal to OAuth 2.0 on its own

We have a connection to one of our Microsoft Fabric data warehouse, and it is connected via a data gateway. We're using Service Principal for authentication. But, for some reason, it automatically ch...
Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    Issue: Fabric sometimes auto-switches your Data Warehouse connection from Service Principal to OAuth 2.0, breaking reports.


    Why: Gateway or workspace settings may not persist Service Principal properly—especially after refreshes or updates.


    Fixes:
    - Recreate the gateway connection and lock it to Service Principal.
    - Disable SSO and set a fixed identity in model settings.
    - Keep your gateway updated.
    - Raise a Microsoft support ticket to escalate.

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
1 year ago

Issue: Fabric sometimes auto-switches your Data Warehouse connection from Service Principal to OAuth 2.0, breaking reports.


Why: Gateway or workspace settings may not persist Service Principal properly—especially after refreshes or updates.


Fixes:
- Recreate the gateway connection and lock it to Service Principal.
- Disable SSO and set a fixed identity in model settings.
- Keep your gateway updated.
- Raise a Microsoft support ticket to escalate.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks, Shahid. Will try your suggestions and see if that helps