ADO.NET error trying to run Python Script in PowerBI

user_1754307 0
Viewed 9194

I have Anaconda which runs this simple script fine:

import pandas as pd
data = [['Alex',10],['Bob',12],['Clarke',13]]
df = pd.DataFrame(data,columns=['Name','Age'],dtype=float)
print (df)

It runs from both Anaconda promprt and normal command prompt, as the path is set to include the Anaconda3 folder.

Trying to use PowerBI, following the Microsoft example, I get:

Details: "ADO.NET: Python script error. Traceback (most recent call last): File "PythonScriptWrapper.PY", line 2, in import os, pandas, matplotlib File "C:\ProgramData\Anaconda3\lib\site-packages\pandas__init__.py", line 19, in "Missing required dependencies {0}".format(missing_dependencies)) ImportError: Missing required dependencies ['numpy']

powerbi anaconda python
3 Answers

I had a very similar error (my missing dependency was xlrd). To get my python script to run in PowerBI I had to install the missing dependency using pip:

C:\>pip install xlrd

My PowerBI points to my Python distribution installed in C:\Python (yours most likely points to Anaconda).

I would try installing numpy through Anaconda and then re-run your Python Script in Power BI.

user_60443120
user_169077980

The short answer is that the solution is launching the Power BI Desktop executable from the Anaconda Prompt after activating the environment in which you want to run the Python script.

The long one is described in this blog post.

user_4169880
Related