Powerbi rest api AddRows -

i working on realtime dashboard, i'd use powerbi rest api.

my question how updating of rows work. have 1300 records load once , update 2 columns each row every 20 seconds.

the rest call see addrows, it's not clear how handles update of rows if does

you have 2 patterns can choose from:

you can send data in batches: upload 1300 rows, call delete on rows, call upload next payload of rows.

here's delete method need all. we're adopting rest standards our apis 'methods' rest verbs :). https://msdn.microsoft.com/en-us/library/mt238041.aspx

alternately can incrementally update data: you'd add 'timestamp' column data set. in query (like in q&a) you'd ask "show data last 20 seconds". if this, set fifo retention policy when create data set don't run out of space.

in either case, double check number of rows you're pushing fit within limits spell out. https://msdn.microsoft.com/en-us/library/dn950053.aspx

hth, -lukasz