Python personal gateway credentials
I'm currently trying to schedule a refresh for a Power BI report which uses python to transform the loaded data.
I can get the python script to run on my local machine in powerbi desktop, but when I publish it and attempt to schedule the refresh, I get an error concerning invalid credentials (Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.). The other data sources connect fine through the personal gateway. When I click on 'Edit Credentials' for Python, I get the following specifics:
Failed to update data source credentials: ADO.NET: Python script error. Traceback (most recent call last): File "PythonScriptWrapper.PY", line 2, in <module> import os, pandas, matplotlib File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\__init__.py", line 19, in <module> "Missing required dependencies {0}".format(missing_dependencies)) ImportError: Missing required dependencies ['numpy']
| Activity ID: | 177ce143-63b1-422a-8852-ca1bef96a846 |
| Request ID: | 9f20ee17-91cb-ab92-75d9-7688929f6157 |
| Status code: | 400 |
| Time: | Fri Feb 28 2020 11:07:32 GMT+0000 (Greenwich Mean Time) |
| Service version: | 13.0.12439.190 |
| Client version: | 2002.3.018 |
| Cluster URI: | https://wabi-north-europe-redirect.analysis.windows.net/
|
I can't see any way to select the python installation to run the script with, but all of my local environments should be able to run the script (notably, they all have numpy installed)
Thanks in advance for your help.
George Kinnell (Altius)
17 Comments
Hi Anonymous ,
Is the on-premises data gateway (personal mode) installed on the same machine as Python directory?
Please check this document, set the Privacy Level of Python data source to Public. See: https://docs.microsoft.com/en-us/power-bi/desktop-python-in-query-editor#limitations
Please update the gateway to the latest version then go to Power BI service, specify the credential for the Python data source to see if the same issue occurs.
Best Regards,
Qiuyun Yuv-qiuyu-msft Yes, they are both installed on the same machine.
The privacy level is set to public and the gateway was only installed last Thursday so is up to date.
It is not possible to specify the credential for the Python data source, this box is greyed out and cannot be selected.
Thanks,
George
I have the exactly same problem.
- have set privacy level to public
- have installed latest on-premises data gateway (personal mode)
- but still get error
v-qiuyu-msft help please!
Hi all,
Sorry for the late response. I would suggest you create a support ticket to let engineers look into the issue on your side.
Best Regards,
Qiuyun YuAny update on this issue? I am having the same problem. I have a personal gateway on my PC which has Python, Power BI Desktop and all.
Hi, have you solve the problem? Similar problem here
Hi v-qiuyu-msft , is there any other way to get technical support for employee of MS
