Forum Discussion

jFloury's avatar
jFloury
Frequent Visitor
1 year ago
Solved

Using msggraph sdk in Fabric notebooks

Hi ! I'm trying to use the msgraph sdk in Fabric notebook, but I'm facing an SSL issue.     import asyncio import msal from azure.identity.aio import ClientSecretCredential from azure.identity i...
workspaces
  • jFloury's avatar
    jFloury
    1 year ago

    Thank you for your answer.

     

    The simpliest way is to add those 3 lines :

     

    import certifi
import os
os.environ['SSL_CERT_FILE'] = certifi.where()

     

    Jérôme

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi jFloury ,

Thank you for joining us on the Microsoft Fabric Community Forum.

 

This error happens because Python can't verify the SSL certificate for the Microsoft Graph API. Basically, it can't find a valid root certificate in your local certificate store. This issue is quite common in custom or isolated environments that don't automatically install root certificates.

 

  • Ensure your notebook environment has the latest root certificates installed. You can do this by updating your environment, or by downloading and installing a new set of certificates. Make sure your system recognizes these new certificates.
  • For custom or missing certificates, specify a CA certificate file (such as ca-bundle.crt) for SSL verification.
  • Inspect Python’s default certificate path to check if any root certificates are missing.
  • If the SSL issue continues, try using a different authentication method, like Device Code Credential. This might help bypass the problem in certain environments
  • Utilize the MSGraph SDK functions to interact with the Microsoft Graph API within your notebook.

 

If my answer addressed your query, kindly mark it as the Accepted Solution to assist others.

I'd also be grateful for a 'Kudos' if you found my response useful!