Forum Discussion
Insert rows question
In PowerQuery you can schedule the query every x mins, so you would suggest using that?
Any idea how?
Hi Anonymous ,
Try having a look through the link I provided to see if it is right for your scenario. It also expains how to do it.
It's the only way I know of to get Power BI to add new snapshot data onto an existing historical dataset.
Pete
I did. but it was not clear to me.
First want to focus how to insert a new row with new data each time....That should be easy, but I cannot find it hahah!
With RPA it is just an insert when the variable is changing...Also, it is not really incremental.
I just need to ADD new data (1 record) every time... 🙂Old data just remains.
Anonymous you can take a look at this article on how to use Incremental Refresh to keep existing data in the model while adding new data. However, just as the article itself suggests, it is not recommended for production, just an interesting exercise. Use at your own risk.
The right way to do this is to store your data in another location and incrementally add data to that. Power BI is meant to do a refresh, wipe, refresh, not keep anything. The Incremental Refresh feature is to simply store older unchanged partitions without wiping them out. If you did, a full refresh would restore the same results, just take a long time. It is not meant to keep data in Power BI that doesn't still exist in the source database. Chris Webb's BI Blog: Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using Incremental Refresh Chris Webb's BI Blog (crossjoin.co.uk)Thanks!
I just don't understand that MS doesn't allow me to keep static data and add rows from other sources 1 by 1...Excel with Power Query or PowerBI, doesn't matter...
Will read your article 🙂
