Code Pope
Code Pope

Reputation: 5459

Real time dashboards in Power BI

In Power BI you have the functions of Power BI REST API to insert rows in your dataset and have live dashboards. The problem with that feature is updating an existing row. There is no UPDATE command in POWER BI REST API.
There is a DELETE Command but it deletes the whole table data and if you have a table with about 500.000 rows, this is not an option.
To implement real time dashboards, I need some kind of UPDATE command or a workaround. Does anybody have an idea for this?

Upvotes: 2

Views: 711

Answers (1)

plamen
plamen

Reputation: 9

Test your requests here : http://www.requestmaker.com/ The UPDATE works by simply sending the updated records only.

Initial dataset: [ { "code" :1, "name" :"City1", "value" :78 }, { "code" :2, "name" :"City2", "value" :85 } ]

Update dataset: [ { "code" :2, "name" :"City2", "value" :85 } ]

Upvotes: 0

Related Questions