Delete rows in a dataset using PowerAutomate

[scarmatoleo1]

Hello!

I'm using PowerAutomate to add rows to a dataset everyday, but, I'm getting the same information over and over again everytime the script runs.

I want to delete the actual rows before adding the ones with the new information, is there a way to do it?

Maybe another step before "Add rows to a dataset" will work, but which one?

Thanks

[v-jianpeng-msft]

Hi, @scarmatoleo1 

There is currently no Power BI automation trigger that directly deletes a row. I guess you can execute the command to delete the data source row before executing the automation flow. Before inserting a row trigger in Power BI, refresh the semantic model to get the latest data for the deleted rows, and then insert the rows.

How to Get Your Question Answered Quickly

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.