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.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

gunjansa_ms ,

 

From the source code below, you may lost hard dependency modules, please check if you have installed: numpy, pytz, dateutil.

# flake8: noqa

__docformat__ = "restructuredtext"

# Let users know if they're missing any of our hard dependencies
hard_dependencies = ("numpy", "pytz", "dateutil")
missing_dependencies = []

for dependency in hard_dependencies:
    try:
        __import__(dependency)
    except ImportError as e:
        missing_dependencies.append("{0}: {1}".format(dependency, str(e)))

if missing_dependencies:
    raise ImportError(
        "Unable to import required dependencies:\n" + "\n".join(missing_dependencies)
    )

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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! 🙂

  • jamesmkfoo's avatar
    jamesmkfoo
    Regular Visitor
    6 years ago

    Thank you Sir gunjansa_ms! I solved it by adding anaconda3\Scripts and anaconda3\Library\bin to PATH variable.

     

  • 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.

  • santoshkoirala's avatar
    santoshkoirala
    Regular Visitor
    6 years ago

    I spent a whole work day trying to debug/fix this issue. After a whole lot of reading posts on google, stack overflow and countless iteration of updating anaconda, uninstall/reinstall numpy, I stumbled across this post. Thanks gunjansa_ms for the workaround. Cannot believe it was as easy as adding a few environemntal variables. Hopefully the PowerBI team fixes this soon or update their documentation to set the path variable. 

  • nmckbcs's avatar
    nmckbcs
    Icon for Helper I rankHelper I
    5 years ago

    Can you guys provide specifically what had to be done here?

     

  • Naveen_SV's avatar
    Naveen_SV
    Icon for Helper IV rankHelper IV
    5 years ago

    How to set this environment varaibles can you send me screenshot