Power BI Service - import os, pandas, matplotlib ModuleNotFoundError: No module named 'pandas'

[Anonymous]

Olá a todos, tudo bem?

Desenvolvi um dashboard usando um script Python para conectar a API. Criei um ambiente virtual com a versão Python e bibliotecas suportadas pelo Power BI, mas só funciona no Power BI Desktop, estar online não funciona, me diz que não encontrou os módulos pandas, matplotlib e etc.

pedidos
de importação import pandas como pd
import json

link_get_all_organizations = " https://api.pipedrive.com/v1/organizations?limit=500&start=0&api_token=TOKEN "
df_response = requests.get(link_get_all_organizations).json()
df_all_organizations = pd.DataFrame.from_dict(df_response['data' ], oriente='colunas')

Local funciona perfeitamente, mas online está exigindo o pacote.

Local

É possível instalar os pacotes no Power BI Service?

[Anonymous]

HI, @v-yueyunzh-msft 

The required credentials are the api token that is in requests.get(), I changed the permission in Power BI desktop and online to Public, and the libraries are installed on the same machine where the Gatway and the dashboard are.

Do you have any other ideas of what it could be?

[v-yueyunzh-msft]

Hi , @Anonymous 

According to your error message, you encountered an error when configuring data source credentials for the gateway, it seems that the error is because the corresponding Pandas module, matplotlib, etc. are not configured and installed on your gateway computer, can you disclose that your gateway computer and your machine are the same? If not, you can go to your gateway computer and install the corresponding Pandas module, matplotlib, etc. and restart the gateway to check if the problem is solved?

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly