refresh only part of API data i.e. recent year, and refresh previous years based on request

[Bassil74]

I have an API with a year parameter, such as ending with /Summary?year=2024. Therefore, my Power BI dashboard will need to fetch data for multiple years like:

```M
Years= Table.FromList({"2018","2019","2020","2021","2022","2023","2024"},null,{"Years"}),
GetData = (Years as text) => Json.Document(Web.Contents(Service&"/Summary?"& Years))[data],
Output = Table.AddColumn(Years, "Output", each GetData([Years])),
```

However, data for years before 2024 won't change. How can I control the refresh to fetch data for 2024 every time I click the refresh button, but for years 2018-2023, it only refreshes as needed and doesn't automatically force refresh when the refresh button is pressed.

Thanks

[lbendlin]

Stuff the historical data into a dataflow or a CSV/Parquet file and consume it from there.

[Bassil74]

Yes, that solution will suffice if I'm the sole user but since the file will be shared publicly i need a more robust mechanism that allow for differentiate data related to certain year so it won't refresh, but only refresh partial data, but thank you in anyway for proposing the above.