Powerbi rest api AddRows

Question

I am working on a realtime dashboard, i'd like to use the powerbi Rest Api.

My question how does the updating of rows work. I have 1300 records to load once and then update 2 columns for each row every 20 seconds.

The only rest call I see is to addrows, but it's not clear how it handles update of rows if it does

Answer 1

You have two patterns you can choose from:

You can send data in batches: upload 1300 rows, then call DELETE on the rows, then call upload with the next payload of rows.

Here's the DELETE method you need to all. We're adopting REST standards for our APIs so the 'methods' are the REST verbs :). https://msdn.microsoft.com/en-us/library/mt238041.aspx

Alternately you can incrementally update the data: You'd add a 'timestamp' column to your data set. Then in your query (like in Q&A) you'd ask for "show data for the last 20 seconds". If you do this, set the FIFO retention policy when you create the data set so you don't run out of space.

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

HTH, -Lukasz