python script error

Question

Hello,&nbsp;My python connection was working but it stopped today and keep on receiving this error message:&nbsp;DataSource.Error: ADO.NET: A problem occurred while processing your Python script.Here are the technical details: Process must exit before requested information can be determined.Details:DataSourceKind=PythonDataSourcePath=PythonMessage=A problem occurred while processing your Python script.Here are the technical details: Process must exit before requested information can be determined.ErrorCode=-2147467259ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonUnexpectedException&nbsp;How do i solve this?

anonymous · Answer

Hi&nbsp;jmandavia,
&nbsp;
Can you please provide more detail information&nbsp;to help us clarify your scenario?(e.g, python version, desktop version, datasource you connect)
&nbsp;
According to your error message, it seems like a script error during progress. Have you double check and debug your code?
&nbsp;
Regards,
Xiaoxin Sheng

shuaho · Answer

I have the similar error, my python script works well outside of PowerBI, but get below error:

We encountered an error while trying to connect.

Details:"ADO.NET:Python script error.

Traceback(most recent call last):

File "PythoScriptWrapper.PY", line 2, in <module>

import os, pandas, matplotlib.pyplot

ImportError: No module name pandas

I don't have pandas in the script, Here is my script:

import requests
import json

url='https://api-XXXXXX.com/api/1.0/authentication/XXXXXXXXX/login'
data='''{
"userName": "XXX",
"password": "XXX"
}
'''
headers = {
"content-Type":"application/json"
}

resp = requests.post(url, headers=headers, data=data, verify=False)
jData = json.loads(resp.content)
token = jData['accessToken']

vshah · Answer

Hello&nbsp;&nbsp;I am getting the same error and unable to proceed further. Is there any way to debug this issue&nbsp;&nbsp;&nbsp;

anonymous · Answer

Have installed Python through Anaconda? That's most likelly the problem. I installed python 3.6 on its own and was able to integrate python script into PBI. Then I installed python 3.7 through Anaconda and got similar error for the same script that gave me no issues previously. I repointed PBI to the 3.6 interpreter and it runs fine again. So the issue is either with python 3.7 or with how it is managed by Anaconda. My guess is it's Anaconda and hence the irony that I went for it for convinience...

vshah · Answer

Thanks a lot for your reply. Will give it a try tomorrow. Will also try downloading python 3.7 directly instead of through Anaconda and check&nbsp;

Forum Discussion

python script error

10 Replies

Related content

Publish .pbip using Python script

Python script error

Power BI Python ADO.NET: Python Script Error

python script error

Python Script Error