Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous ,

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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... :smileyfrustrated:

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago
        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