Python LibrarIes in PBI Query

[Jaruisenor]

Hi! so I am using an API Wrapper for the CRM called pipedrive in order to use the Power Query in Power BI to import a customed table (panda dataframe). This information cannot be retrieved using the REST API from pipedrive so I have to resort to use Python Scripting within the Power Query (which has worked before to call for POST requests in REST API). 

The issue is that in order to use this pipedrive library (API Wrapper) to obtain and retrieve information from the software and more specifically the user account, I need to do a pip install inside the enviroment (which I did and works). I am able to construct the dataframe with no problem with a jupyter notebook using the Anaconda enviroment. When it comes to use the code in the 'Get Data' with Python scripting I am having an ADO error saying it doesnt recognize the 'pipedrive' module as I have to use 'import pipedrive.client' in order to use the library.

Power BI Python integration has no big problem using classic libraries such as numpy, pandas, etc but when it comed to use other more non conventional libraries It appears to have problems. Eventhough the library is correctly installed in my enviroment Power BI doesnt let me use it inside the scripting to get my information. Any help or ideas would be very much appreciated.

[v-shex-msft · Accepted solution]

Hi @Jaruisenor,

Yes, this is a known limitation of using python visuals.
For security reasons, power bi service only supports general libraries and it will block some advanced operation(such as invoke external resource or access to specific website)

Power BI Security#data-storage-security 

For your scenario, you can consider package these steps as bridge web service/API to use web connector get result data instead of do these operations within a python script. (power bi service security trace operations from internal contents but it does not check the external operations that out of power bi)

Regards,

Xiaoxin Sheng