Python script error: 'No module named pandas'

[Anonymous]

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.

[Anonymous]

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

[ingdanielrayez]

This work for me in PBI Desktop

[Anonymous]

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.

[marcoabgm]

Hello!

We are facing same here!

Have you figured out how to solve?

[v-lili6-msft]

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