Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.