Forum Discussion

ADTRE's avatar
ADTRE
Frequent Visitor
2 years ago

Identify deleted rows from Microsoft List to PowerBI Semantic Model

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.

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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. 

  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    Icon for Super User rankSuper User
    2 years ago

    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 

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional
    2 years ago

    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's avatar
      ADTRE
      Frequent Visitor
      2 years ago

      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's avatar
        christinepayton
        Icon for Most Valuable Professional rankMost Valuable Professional
        2 years ago

        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.