Forum Discussion

Bassil74's avatar
Bassil74
Icon for Helper I rankHelper I
2 years ago

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

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","20...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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

  • Bassil74's avatar
    Bassil74
    Icon for Helper I rankHelper I
    2 years ago

    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.