Refresh data in a period and store the old data with Data from Web.

[Thai_Nguyen96]

Hi all,

I have some open APIs which created to get data from source. I try the feature get data fro Web in Power BI and it get successfully. I also set up daily refresh for this data set.

My question is can I just refresh the data in a period (1 months,...) and store the old data (like incremental refresh) for the source?

[amitchandak]

@Thai_Nguyen96 

Refer:https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

[Thai_Nguyen96]

hi @amitchandak , @Wimverh ,

I get data from Web API, the source data is stored in the outside. Can I use incremental refresh for this type of dataset? I read that is not recommend use for source doesn't support query folding.

[Wimverh]

Incremental refresh is available in pro. 

You use this, read this article for more info

https://powerbi.microsoft.com/en-us/blog/incremental-refresh-is-generally-available/