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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks. Anyways date can be locked to current and retained to use as history to trend you think?

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, Anonymous 

    Date created by function 'DateTimeZone.LocalNow()'  is dynamic and will change based on ‘today’. It will not be retained to use as history once you refresh the report.

    I think you may also need to disable the option 'include in report refresh'.

     

    Best Regards,
    Community Support Team _ Eason

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for the solution. is there a workaround to keep the prvs date static and then append new data by writing a code ? 

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        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