fetching financial data of public companies in power bi

[Wolfdinger]

Hello,

I'm trying to import financial data of public companies into power bi (income statement, balance sheet, cash flow) for last five years quartly or yearly.

I'm bit surprised I can't find a lot online regarding this.

I found some solutions about getting data of one company importing it from from web in excel or via api in python. 

I wonder isn't there a way to do this for more than one comapny in power bi and in a smooth way?

Thanks

[v-shex-msft · Accepted solution]

Hi @Wolfdinger,

You can refer to the following link to use python script as data source to scrape data from web:

Power Bi Dashboard using web scraping with Python | Medium

Regards,

Xiaoxin Sheng

[amitchandak]

@Wolfdinger , You have to use the web/web scrapping in power bi too