Insert rows question

Question

Hi,&nbsp;I am calling an API and retrieving 1 value, however I want to keep this value in a longer list.So not actually 1 insertrow, but every e.g. 5 minutes, getting the latest value and add this to the list of old values.&nbsp;I have 2 challenges:1. how can I insert a new record every time?2. eventually I can schedule this, or in Power Query schedule as well, but first point 1! 🙂&nbsp;&nbsp;e.g.:Current list/table:123456789&nbsp;New value: 521&nbsp;New list:123456789521&nbsp;5 mins later, new value: 172&nbsp;New list:123456789521172&nbsp;etc.So I need to store the old value and 5 minutes later (or with refresh) store the new value.I was trying this in Excel with PowerQuery, but maybe PowerBi is better doing this?&nbsp;

edhans · Answer

Anonymous&nbsp;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&nbsp;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.&nbsp;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)

edhans · Answer

Because Power BI isn't a data warehouse. It wasn't designed to be. It is not meant to be the only source of truth, and that is what you are asking it to do. You need to build your data warehouse a different way, then connect Power BI to it. It is a read only reporting tool, not a data repository.

edhans · Answer

Yes, and if you republish your report and lose history, you will lose the data. Again, if circumstances are perfect, you can do this. If not, you will lose your historical data. Proceed with caution. You are using the tool in a way not intended. I hope it works for you.

ba_pete · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
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.
&nbsp;
More info:
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview&nbsp;
&nbsp;
Pete

anonymous · Answer

In PowerQuery you can schedule the query every x mins, so you would suggest using that?Any idea how?&nbsp;

Forum Discussion

Insert rows question

10 Replies

Related content

Table insert / rows to group

Bookmark questions

Insert intermediary rows on matrix table

Insert Calculated Rows

Insert row for missing repeating sequence in a table