Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Delete rows in a dataset using PowerAutomate

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

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

    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.