Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Call semPy libraries as service principal

I have a notebook that I wish to get information from all datasets across my tenancy. I have been able to do this for workspaces my account has access to, but I need to do this for all workspaces. I ...
notebook
  • Anonymous's avatar
    Anonymous
    1 year ago

    HI Anonymous,

    After I double checked these credentials that we provide in the notebook. It seems not really used for the sempy functions authorizations.

    They only initialed for Fabric RestClient and corresponding functions uses. For the default sempy functions, they still invoked the current user credentials that notebook and its sessions cached.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous,

Perhaps you can tried to use azure keyvault to get the service principal credentials and use in notebook:

secret = mssparkutils.credentials.getSecret('https://key-vault-datasarva.vault.azure.net/', 'secret-value')

Using Azure Key Vault in Microsoft Fabric Notebooks
Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous 

 

I have incorporated your suggestion, meaning my client secret now looks like this:

client_secret = mssparkutils.credentials.getSecret('https://my-key-vault.vault.azure.net/', 'My-Secret-Name')
 
Unfortunately it hasn't worked. I think there's a complete disconnect between the authentication at the start of my script setting up my fabric client authentication, and the next code segment that calls the fabric.list_datasets method.
 
How can I connect the two, so that when fabric.list_datasets is called, it will use the authentication in the code above? At present its still using my account as my script works when I use a workspace ID that my account has access to, but fails when I use a workspace ID that my account does not have access to.
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    HI Anonymous,

    After I double checked these credentials that we provide in the notebook. It seems not really used for the sempy functions authorizations.

    They only initialed for Fabric RestClient and corresponding functions uses. For the default sempy functions, they still invoked the current user credentials that notebook and its sessions cached.

    Regards,

    Xiaoxin Sheng