cancel
Showing results for 
Search instead for 
Did you mean: 

using python in power bi

My python version is: Winpython64-3.7.4.0 and my PowerBi version is: Power BI Desktop (September 2019)

 

This is what I have done:

  1. loading a csv file into Power BI
  2. then, home>Edit Querries> this will open a new window. In this window, I went to Transform> Run Python Script > after choosing that, a new window opens that I am supposed to write a python code. I tried different options such as: no code, or a simple code (import pandas as pd; df=pd.DataFrame(dataset)). None of them works! I just recive error below. 

"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=Python
DataSourcePath=Python
Message=A problem occurred while processing your Python script.
Here are the technical details: Process must exit before requested information can be determined.
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonUnexpectedException"

 

I deeply appreicate if you could help me to fix this issue! I already spent mopre than 1 day on this 

 

 

Status: New
Comments
v-chuncz-msft
Community Support