Forum Discussion

gunjansa_ms's avatar
gunjansa_ms
Icon for Microsoft Employee rankMicrosoft 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
Icon for Microsoft Employee rankMicrosoft Employee
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.

HeliosOne's avatar
HeliosOne
Frequent Visitor
6 years ago

gunjansa_ms 

Could you explain how actually you define PATH variable with paths in your message? I am facing same problem and my skill is not enough to fix this. A little guide would be great.

Thank you!

  • gunjansa_ms's avatar
    gunjansa_ms
    Icon for Microsoft Employee rankMicrosoft 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! 🙂