Forum Discussion

AndyDDC's avatar
AndyDDC
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

hi WDarwish @I don't think there's any specific documentation in the fabric docs, but you can follow this guide here to create a service principal https://learn.microsoft.com/en-us/purview/create-service-principal-azure

 

then you give the service principal the required permissions in the workspace or on the warehouse itself.

 

then to use the service principal is going to depend on your application

WDarwish's avatar
WDarwish
Frequent Visitor
2 years ago

I actually created the principal as per this very same guide. I cannot get that principal to show up within Fabric WH when sharing or setting permissions.

    • WDarwish's avatar
      WDarwish
      Frequent Visitor
      2 years ago

      Great find! Exactly what I was after. Managed to authenticate using the principal and got things running. Thank you.

      • kjellvs's avatar
        kjellvs
        Icon for Helper I rankHelper I
        2 years ago

        I am trying to achieve the exact similar thing, however when authenticating with 

        ClientSecretCredential in python, I am unable to write to the warehouses. I am able to read from the same warehouses though.
         
        More specifically, I get the following Error:
        The INSERT permission or external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Rows/Insert' was denied on the object '[table]', database '[warehouse name]', schema 'dbo'.
         
        When using AzureCliCredential, this problem does not persist. 
         
        I have tried making the service principle admin (similar to my az credentials), but that also did not help.
         
        Any clue how to have the service principle write to the warehouse?
        kind regards,
        Kjell