python's yfinance returns data from command line but i dont even get a dataset in pbi

[db042190]

Hi , v-binbinyu shared this with us...   https://towardsdatascience.com/best-5-free-stock-market-apis-in-2019-ad91dddec984 .

I was able to list stock ticker MSFT history from my pc's command line but i show nothing (not even a dataset) when i go thru the same steps in setting up a pbi python connector.  Can someone help?

my script was entered in pbi as follows but even after reboot i couldnt get a dataset in pbi:

import yfinance as yf
msft = yf.Ticker("MSFT")
msft.history(period="max")

[db042190]

the history method can do it too.  Had I coded my script like this, it would have worked too.  Notice an object (dataset2) is assigned/points at the results of the history method.

import yfinance as yf
msft = yf.Ticker("MSFT")
dataset2=msft.history(period="max")

[db042190 · Accepted solution]

i'm not sure if the history method can ever act in this capacity and i did see pbi alternatives that use web sources instead of python for this same purpose but this seems to work...i dont think dataset is a key word.  The last 2 statements apparently add columns to what the download method already offers.  I'll be looking up/for ways to make the download method show more tickers and the symbol itself rather than the hardcoded stock name.

import yfinance as yf

dataset=yf.download('MSFT','2010-01-01','2023-06-30')

dataset["Date"]=dataset.index

dataset["Stock"]="Microsoft"