Identify deleted rows from Microsoft List to PowerBI Semantic Model

[ADTRE]

Hi. Example of Microsoft List below:

ID	Column
1	Hello
2	Hi
3	Greetings

I built a new streaming dataset (API) in Power-BI which has the same column names as the Microsoft List. I then used Power-Automate to add rows to this dataset via:

Issue: There are instances when some rows in my Microsoft List need to be deleted (e.g. user error). These deleted rows still get captured in then Semantic Model (and therby in my final report). How can I identify deleted rows in this scenario and then remove them in my final Power-BI report.

[christinepayton]

Why are you adding rows to a dataset instead of just connecting to the list in Power BI directly? If you use the SP list connector, it will automatically get all updates to the items when it refreshes, including adds and deletes. 

[ADTRE]

There are scenarios when adding rows to a dataset is more efficient - such as a survey response that will trigger a data flow. Of course, there are instances when a survey response is incorrect so I need to identy a way to delete it from my dataset.

[christinepayton]

I really don't think it is. If you're worried about efficiency, you can use incremental refresh to only get the new item rows. 

[SaiTejaTalasila]

Hi @ADTRE ,

You are adding new rows to the dataset.As per my understanding you have two options -build a power shell script to delete those rows from semantic model by applying suitable condition.or use run a query against a dataset and copy the data to SharePoint Excel delete those rows from Excel and drop entire data from your dataset and reload data from that Excel to your semantic model.

Thanks,

Sai Teja 

[Anonymous]

Hi @ADTRE ,

From your screenshot it looks like this trigger doesn't seem to be triggering the deleted item, I suggest you head over to the Power Automate forums for help.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

Best Regards,

Neeko Tang

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