Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

extract as table

How do I extract the data in below link as table pl?   https://trendlyne.com/equity/calendar/all/all/?start_date=2021-11-09&end_date=2021-12-08&corporate_actions=Results Used web scraper to get to...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    You can follow the steps below to store  previous data tables.
    1.disable the query refresh of  prvs table

    2. add a static column 'CreatedDate'

    Then use  Union function to append the previous tables and current table in Report View.

     

    In fact ,PowerBI is not suitable for the import and storage of historical data.

    If possible, I suggest that you store these historical data through SQL SSMS / EXCEL sheets each time.

     

    Best Regards,
    Community Support Team _ Eason

     

VijayP's avatar
VijayP
Community Champion
4 years ago

Anonymous 
Create a custom column and add this function which creates today's date based on your regional settings and whenever you are downloading this represent that day automatically. But it changes based on each current day

DateTimeZone.LocalNow()

 

if you find my solution is fine then please mark this as accepted solution