Forum Discussion
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...
Stuff the historical data into a dataflow or a CSV/Parquet file and consume it from there.
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.
