Forum Discussion

aki-siponen's avatar
aki-siponen
Frequent Visitor
1 year ago
Solved

Azure SQL database connection using a service pricipal fails with "the refresh token expired"

Hi, In Microsoft Fabric I'm trying to create a connection to an Azure SQL Database using a service principal.   The creation fails every time with an error: "Unable to create connection for the fo...
  • v-veshwara-msft's avatar
    1 year ago

    Hi aki-siponen ,
    Thanks for using Microsoft Fabric Community,
    As lbendlin  mentioned, you can re-enter the data source credentials in the Semantic Model settings within the Fabric UI.

    To do that,

    1. Go to Semantic model settings-> Data source credentials.

    2. Click on Edit Credentials. 

    3. Sign in with an account that has database access to regenerate the expired OAuth token.

     

    This triggers a token refresh and resolves most "refresh token expired" errors.

     

    Hope this helps! Please feel free to reach out for further assistance.

    If this post is helpful, kindly consider accepting it as the solution to assist other members in finding it more easily. A kudos would also be appreciated!

     

    Regards,
    Vinay.