Forum Discussion
Get data from a Dynamic Webpage - How to change the table selector
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
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:
- 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-srchSince 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 ,
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,
LydiaLygia, Yahoo Finance API was discontinued in May 18, 2018. So, we need to pursui another path to find out a solution.