title: Power BI Desktop incremental table update from Power Query
body: <p>I'm gathering my data from a third-party REST API which has many thousands of records but updates each day with many more and so refreshing my data sources becomes a long task. So I was wondering if there was any way to do incremental loads and only scrape the last 30 days worth of data from the API and append that to a table in PowerBI Desktop.</p>
  
  <p>I've looked into the append queries feature but this seems to only be able to join 2 queries and return a single table, which would eventually run into the same problems as the appending query will grow very large over time.</p>
  
  <p>What I'm really looking for is a way to have a table in PowerBI which then gets updated on each query refresh. Has anyone seen if this is possible?</p>
  
  <p>Any help would be great, thank you.</p>