Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to append data in table B generated at refresh time in table A?



I am all new to BI and are trying to record som weather data from (OWM). I have successfully established an API-connection with OWM.


Here is my problem:


In I BI have two tables, one containing id's for a cities and another with contry codes for a list of countries. These tables are used in parameters such that I can choose which city i want weather data for. 


The data from OWM is loaded into a third table names Curr_Weather. This table generates one single row of data. At every refresh, this row is overwritten by new data.


However, i would like to record the generated row in another table names Aggregated_Curr_Weather and at each refresh add a new row with the freshly loaded data from Curr_weather.


I have searched the internet looking at append function and incremental refresh which i do not have access to.


thx for help.



Community Support
Community Support

Hi @jmgcornator ,


You may use Incremental refresh for your OWM data source, the Incremental refreshes only data that has changed. Since incremental refresh is Premium only feature, so you may need to purchase Power BI Premium capacity for your organization, see How to purchase Power BI Premium.


Incremental refresh policies are defined in Power BI Desktop and applied when published to the Power BI service. See more detail steps: Incremental refresh in Power BI Premium .


You can refer to the link to learn How to: Create a Weather Dashboard with Power BI and API .

(Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.)


Best Regards,



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @v-xicai 


I have already considered the incremental refreshing function, however, it is not a possible solution. 


Thanks anyways 🙂  

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors