Save website data from being overwritten after each refresh

Power Query
1

Hi All,

Does anyone know of a way to save website data from being overwritten, without doing a manual merge? For example, we can pull the price of ink from the warehouse stationary website, but when the report is refreshed, the data is overwritten. Is there a way to keep the old data, and also bring in the new prices? Attached PBIX sample file attached

Thanks!
Ink Prices.pbix (21.1 KB)

2

Hi @Juju,

That will require incremental refresh…

1 Like
3

Hello @Juju

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

1 Like
4

Hi @Juju

Due to inactivity, a response on this post has been tagged as “Solution”.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey,.

We hope you’ll give your insights on how we can further improve the Support forum. Thanks!

5

Thank you!