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.

dpy2310's avatar
dpy2310
New Member
4 years ago

I had already added these in environment variable PATH, I had another extra step was to start Power BI go to --> File --> Options and Settings --> Options --> Python scripting --> Change Detected Python IDEs: "Other" and select "C:\Users\<username>\Anaconda3\Scripts\conda.exe" ****Note: this path depends on where you installed conda.exe --> OK.

 

Restart Power BI and then any script works.

 

Thanks

hmvinuezaB's avatar
hmvinuezaB
New Member
4 years ago

Thanks a lot, with this final step I fixed the issue.