Get data from a Dynamic Webpage - How to change the table selector

[Mark_Thim]

Hi, I'm trying to get from web. I need the Income Statement (Quarterly data) for Apple from Yahoo Finance website: https://finance.yahoo.com/quote/AAPL/financials?p=AAPL&.tsrc=fin-srch

Any idea on how to manipulate the table selector (Annual /Quarterly) to extract Quarterly data instead of Annual data which appears in the initial page?

Regards,

Mark

[Anonymous]

@Mark_Thim ,

Based on my test, when we change the table selector, the link of the website doesn’t change, the website uses JavaScript function to get and organize the data. As a result, it is not supported to get data of Quarterly data to PowerBI directly.

As a workaround, we can copy the data on this selector and paste it on a Excel sheet, then import the Excel to PowerBI.

Regards,
Lydia

[Mark_Thim]

Thanks for feeding back, agree that copying and pasting is a work around but that would require me to repeate this task every quarter for every share I analyse. Is that the best PBI can offer me? To be quite honest I'm not impressed with PBI capabilities to get data from Web... 

[Mark_Thim]

Hi, I'm trying to get from Yahoo Finance. I need the Income Statement (Quarterly data) for Apple from this link: https://finance.yahoo.com/quote/AAPL/financials?p=AAPL&.tsrc=fin-srch

Since the page address does not change, I have not managed to extract Quarterly data instead of Annual data which appears in the initial page.

Does anyone has a clever suggestion on how to manipulate the table selector (Annual /Quarterly)?

Regards,

Mark

[Anonymous]

@Mark_Thim ,

You can contact  Yahoo Finance support to check if it provides any Rest API to get the  Quarterly data, it is possible to connect to REST API in web connector of Power BI Desktop.

Regards,
Lydia

[Mark_Thim]

Lygia, Yahoo Finance API was discontinued in May 18, 2018. So, we need to pursui another path to find out a solution.