Forum Discussion

AlvinB's avatar
AlvinB
Frequent Visitor
1 year ago
Solved

Using a 3-rd party library (Databricks) in Power BI Service

Hi all,

I need to use a 3rd party SQL connector called 'databricks-sql-connector' in the Power BI Service.

 

I tested below and it was succesful:

 

Above scripts are in the same notebook.

 

My question is:

- Is it a right way to use a 3rd party library?

- Do I need to include and run 'pip' installation command every time in a Notebook?

- I would like to know if there is a way to install a 3rd party library so I can import the library in a Notebook not by installing every time when I excute a Notebook

 

Thanks for your help in advance.

 

 

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi AlvinB ,
    Thank you for reaching out to us on Microsoft Fabric Community Forum!

    1.Yes, using pip install in your notebook is the correct and supported method to use third-party Python packages in Microsoft Fabric Notebooks.

    2.Yes, currently Fabric Notebooks are session-based and do not retain installed packages between sessions. You may  need to run the pip install command at the start of each session.


    3.No, at this time, Fabric does not support. Installing them via pip in each notebook remains the required approach. Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on.

    Hope this resolve your query. If so,give us kudos and consider accepting it as solution.

    Regards,
    Pallavi.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi AlvinB ,
    Thank you for reaching out to us on Microsoft Fabric Community Forum!

    1.Yes, using pip install in your notebook is the correct and supported method to use third-party Python packages in Microsoft Fabric Notebooks.

    2.Yes, currently Fabric Notebooks are session-based and do not retain installed packages between sessions. You may  need to run the pip install command at the start of each session.


    3.No, at this time, Fabric does not support. Installing them via pip in each notebook remains the required approach. Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on.

    Hope this resolve your query. If so,give us kudos and consider accepting it as solution.

    Regards,
    Pallavi.