Delete specific data from a streaming data set

[MattBH]

Hi guys, I have a MS form that is completed, Power Automate runs and sends that data to Power BI. My question is, if a person incorrectly completes the form and submits it. Am I able to delete that specific data within Power BI?

I understand I can completly wipe all of the Power BI data and start fresh, however I would only need to remove the incorrect forms data.

Is this possible?

thanks

[nickyvv · Accepted solution]

@MattBH,

I'm afraid that's not possible today.

The REST API also does not have this possibility, you can only delete all rows with Push Datasets - Datasets DeleteRowsInGroup.

[MattBH]

Thanks @nickyvv , would you happen to know if I could create a flow within automate that deleted the BI data if a completed MS form was deleted? Or to your point, that also would be impossible.

[nickyvv]

@MattBH,

I think that's possible, but again, you would be deleting the whole dataset in Power BI.