Forum Discussion

Kieran_choudary's avatar
Kieran_choudary
Helper I
9 years ago

Query to refresh recent data only, while keeping the old

Hi Guys,

 

I was wandering if anyone knew how to make my Power BI ony refresh latest data, i still want to view last year and this years data in one report, but refreshing takes a long time

 

I am accessing through SQL 

 

Any help would be greatly appriciated

Need Help

4 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    i could be completely wrong, but if you create a table for the old data, and remove the enable load on the table in the query editor, and then create a new table for the new data and append the new data to the old data in a separate table, work that work?

    • Kieran_choudary's avatar
      Kieran_choudary
      Helper I
      9 years ago

      HI thanks for your reply, i tried that and linked both set to the same date table, but the many of the charts one let you have multple values, so i wouldnt be able to should all in one visual