Skip to main content
Microsoft Idea

Synapse

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