Forum Discussion
Python script error: 'No module named pandas'
I tried getting data with a python script and recieved the following error:
Details: "ADO.NET: Python script error.
Traceback (most recent call last):
File "PythonScriptWrapper.PY", line 2, in <module>
import os, pandas, matplotlib.pyplot
ModuleNotFoundError: No module named 'pandas'
"
Here's the python code:
import datetime
import fix_yahoo_finance as yf
start = datetime.datetime(2016,1,1) #start with January 1st 2016
end = datetime.date.today()
fb = yf.download('fb', start, end) #fb call
fb['Name'] = "fb"
nflx = yf.download('nflx', start, end) #nflx call
nflx['Name'] = 'nflx'
aapl = yf.download('aapl', start, end)
aapl['Name'] = "aapl"
stocks = fb.append([nflx, aapl])
stocks['date'] = stocks.index
The code runs perfeclty fine in PyCharm so it seems to be a PBI issue.
5 Replies
- AnonymousNot applicable
Anonymous Please install all the packages that you are mentioning in the python script in Power BI, explicitly in Command Prompt.
Open Command Prompt > for example, type in " py -m pip install pandas" without quotes and then try running the py script in Power BI.
It worked for me.
Cheers.
- AnonymousNot applicable
have the same problem. How do I open CMD in Power BI online to install modules?
My dash works on Desktop, but when I go online it says it didn't find the modules.
- marcoabgmRegular Visitor
Hello!
We are facing same here!
Have you figured out how to solve?
- ingdanielrayezRegular Visitor
This work for me in PBI Desktop
- v-lili6-msft
Community Support
hi, Anonymous
I'm not a Python script experts I did a lot of searching for this error, there is no result about Power bi,
It seems to be a Python issue. You may try some solutions about it.
If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.
Best Regards,
Lin