Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Error when connecting python to PBI

  Hi, Despite the fact that I do have Python installed when I'm trying to connect it to PBI I get an error message:   Unable to connect: Details: "ADO.NET: Python script error. Traceback (most ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    As I found out yestreday the issue was due to Power Bi not supporting Python 3.7. i had to created new env for py36 and it worked form there!

     

    Thank you

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

From what I am seeing in your error message, it looks like you are missing a Python package "numpy".

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Which doesn't make sense as I have it installed :

 

  • Minseven's avatar
    Minseven
    Helper I
    7 years ago

    is you PATH environment match what you have in your options?

    to check your environement:

    1) Open the Python Shell and

    2) type:

    import sys
    print(sys.exec_prefix)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yes it is the same :

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous,

         

        Since you have two different release of Python, I'm afraid the Numpy is in Python37 rather than in the Anaconda. Please check out. You can do it like below.

        pip list -v

        Error-when-connecting-python-to-PBI

         

        Best Regards,
        Dale