Running interactive python scripts in PowerBI

[Tanushreenarain]

Hi,

I have been encountering error running python scrips in Power BI for vizualization purposes. Moreover, I wanted a clarification if i can run interactive python scripts in PowerBI.

I am encoutering the following error - 

DataSource.Error: ADO.NET: Python script error.
<pi> File "C:\Users\tntnt\PythonScriptWrapper_f90e4d92-b03b-4487-a5fc-ea2bdcf74827\PythonScriptWrapper.PY", line 16
df_pr_data=pd.read_excel('C:\Users\tntnt\Desktop\ADM.xlsx')
^
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape
</pi>
Details:
DataSourceKind=Python
DataSourcePath=Python
Message=Python script error.
<pi> File "C:\Users\tntnt\PythonScriptWrapper_f90e4d92-b03b-4487-a5fc-ea2bdcf74827\PythonScriptWrapper.PY", line 16
df_pr_data=pd.read_excel('C:\Users\tntnt\Desktop\ADM.xlsx')
^
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape
</pi>
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException

Looking forward to a response.

[lbendlin]

that error is caused by your source data. And no, you cannot have interactive Python visuals. Only static renderings.