Forum Discussion
Power BI Python Script Issue
# Import the translation library
from textblob import TextBlob
# Create a function for translation
def translation(text):
blob = TextBlob(text)
return str(blob.translate(from_lang='ar', to='en'))
# Apply the translation function to the relevant column in the dataset
dataset['translation'] = dataset['Comment'].apply(translation)
i couldnt resolve the below issue:
DataSource.Error: ADO.NET: Python script error.
<pi>Traceback (most recent call last):
File "C:\Users\romany.fahmy\PythonScriptWrapper_f98538af-0b94-4b4f-8564-167f0283ffcc\PythonScriptWrapper.PY", line 2, in <module>
import os, pandas, matplotlib
ModuleNotFoundError: No module named 'matplotlib'
</pi>
Details:
DataSourceKind=Python
DataSourcePath=Python
Message=Python script error.
<pi>Traceback (most recent call last):
File "C:\Users\romany.fahmy\PythonScriptWrapper_f98538af-0b94-4b4f-8564-167f0283ffcc\PythonScriptWrapper.PY", line 2, in <module>
import os, pandas, matplotlib
ModuleNotFoundError: No module named 'matplotlib'
</pi>
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException
4 Replies
# 'dataset' holds the input data for this script
# Import the translation library
from textblob import matplotlib.pyplot as plt# Create a function for translation
def translation(text):
blob = TextBlob(text)
return str(blob.translate(from_lang='ar', to='en'))# Apply the translation function to the relevant column in the dataset
dataset['translation'] = dataset['Comment'].apply(translation)
after your update the below issue appeared:
DataSource.Error: ADO.NET: Python script error.
<pi> File "C:\Users\romany.fahmy\PythonScriptWrapper_1a152b9c-825d-4fbb-b52c-05213fa30147\PythonScriptWrapper.PY", line 18
from textblob import matplotlib.pyplot as plt
^
SyntaxError: invalid syntax
</pi>
Details:
DataSourceKind=Python
DataSourcePath=Python
Message=Python script error.
<pi> File "C:\Users\romany.fahmy\PythonScriptWrapper_1a152b9c-825d-4fbb-b52c-05213fa30147\PythonScriptWrapper.PY", line 18
from textblob import matplotlib.pyplot as plt
^
SyntaxError: invalid syntax
</pi>
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeExceptionHi Romani check community experience for your error
Hi Romani ,
Does the information provided by some_bih help you solve your problem? If it helps, please accept the responses you find helpful as solution.
Best Regards,
Dino Tao
