Skip to main content

    Data Science

    Under Review

    Add support for office PIPs into Fabric Notebooks (Python)

    Vote (4) Share
    Bob Duffy's profile image

    Bob Duffy on 29 Aug 2023 13:23:10

    Its very common to need to integrate Fabric PySpark into office to download excel files. Currently this is difficult to do and if we do a pip install at Library level, the startup times is too slow.


    Can we get the following PIP installs into the standard Spark "Started" image ?

    pip install msoffcrypto-tool

    pip install Office365-REST-Python-Client


    This would add support for reading and writing files from SharePoint using Notebooks and also to support password encrypted excel files



    Misha Desai (administrator) on 29 Aug 2023 21:09:17

    Thank you for the feedback. To clarify, are you looking for support to run inline installation within the notebook or are you looking to have the libraries listed part of the default Fabric runtime?

     

    For running inline Python installations with PIP, you can do this at the session-level: Python library management in Fabric - Microsoft Fabric | Microsoft Learn.