Edit and delete data with API

[Mikaeljohansson]

Hi

I have created a simple loggbook in sharepoint where our employees fill in incidents during their shift. I use a flow to populate a table  (with API) shown in our dashboard for daily meetings.
An issue that we have, and that will decide the future use of power BI or software change, is that we can add rows but when we edit a row it adds it again. We cant delete a row either.  Is this att all possible? 

[ranbeermakin]

Hi there,

You can do that in Power BI Model. Pick the most recent row. I assume you have some row id or unique id to identify a row, and a modified or inserted date column.

Ranbeer

[Mikaeljohansson]

I have added unique ID to each row but can't seem to figure out how to filter by latest ID in a table view. Where do I find that function?

Thanks

[Mikaeljohansson]

@ranbeermakin  So, what I have is a sharepoint list. This is a logg book that both adds new loggs and uppdates others. I hear that I can use "X-PowerBI-PushData-SequenceNumber" But that is a bit beyond my scope att the moment.

This is my API att the moment:

[

{

"Title" :"AAAAA555555",

"Område" :"AAAAA555555",

"Datum" :"2020-04-20T10:23:25.758Z",

"Information" :"AAAAA555555",

"Avslutad" :"AAAAA555555",

"Eskalerad" :"AAAAA555555",

"Signatur" :"AAAAA555555",

"Ansvarig" :"AAAAA555555",

"Aktivitet" :"AAAAA555555",

"Beräknad klar" :"2020-04-20T10:23:25.758Z",

"Kommentar" :"AAAAA555555",

"Safety" :"AAAAA555555",

"Quality" :"AAAAA555555",

"Delivery" :"AAAAA555555",

"Cost" :"AAAAA555555",

"Working Climate" :"AAAAA555555",

"Environment" :"AAAAA555555",

"eskal_calc" :98.6,

"Key" :98.6

}

]

I use flow to push data with the oncreate or uppdate function.

What do I need to add to make sure only the latest version of the logg is used?

Thank you

[Mikaeljohansson]

I have yet to find a program as expensive and function lacking as Power BI be so unstable. With each uppdate, gateways stop working, functions get removed and it is a mayor pain, office 360 support is a joke.  All departments have decided to go for node red and Pie chart.