Forum Discussion
Insert rows question
Hi Anonymous ,
The only way I think you can do this with Power BI is by using incremental refresh in the Power BI Service.
You need a Premium Capacity or Premium-per-User licence.
More info:
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
Pete
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.