Forum Discussion

gunjansa_ms's avatar
gunjansa_ms
Microsoft Employee
6 years ago
Solved

Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException-Transforming data python

Facing error while trying to transform data in powerbi using python script.  For initial script just tries to print string print('done') But this fails statin below error. Have installed Python ve...
  • gunjansa_ms's avatar
    gunjansa_ms
    6 years ago

    I was able to fix this. There is no issue with installation of libraries. 

    Bug is there in PowerBI. Even after providing the path of Python in settings, it expects environment variable PATH to be set with below paths.

    C:\Users\gunjansa\AppData\Local\Continuum\anaconda3

    C:\Users\gunjansa\AppData\Local\Continuum\anaconda3\Library\mingw-w64\bin

    C:\Users\gunjansa\AppData\Local\Continuum\anaconda3\Scripts

    C:\Users\gunjansa\AppData\Local\Continuum\anaconda3\Library\bin

     

    Please get this fixed as this is an unnecessary additional step which took 3 days to debug the issue.

gunjansa_ms's avatar
gunjansa_ms
Microsoft Employee
6 years ago

Go to Properties of your PC.

Go to Change settings

Go to Environment Variables

Go to Path in System Variables. Add Paths.

 

C:\Users\gunjansa\AppData\Local\Continuum\anaconda3

C:\Users\gunjansa\AppData\Local\Continuum\anaconda3\Library\mingw-w64\bin

C:\Users\gunjansa\AppData\Local\Continuum\anaconda3\Scripts

C:\Users\gunjansa\AppData\Local\Continuum\anaconda3\Library\bin

 

HeliosOne's avatar
HeliosOne
Frequent Visitor
6 years ago

gunjansa_ms  perezco

 Thank you guys for that explanation. You are real Python ninjas! 🙂