Forum Discussion
Delete information from dataset
Hello people!
Is there any option to delete rows Power BI from Microsoft Flow?
The scenario is the next one: I'm doing Charts of sales and orders from my company, the problem is the following one, I want to do a card report from all orders that are pending. This information changes constantly and at the moment I only have found how to increase the counter but not how to decrease it, is this option available?
I use Microsoft flow events to do that, for example: when an order is submitted add rows to the dataset.
Thank you so much for your attention!
6 Replies
Anonymous You would need to either recalculate how you determine what is pending, or update the datasource that Power BI is connected to... there is no option to modify the cached data outside of refresh - which means you have to go back to the source of information, or change the calculation of what is "pending".
Hi Anonymous, first of all, thank you so much for taking the time to reply to my post.
The problem is once that a row is a dataset is not able to remove from there.
When an order is submitted automatically is added the row with his ID to the dataset and his status is "Pending", but when this order is accepted, the status changes to "Accepted" so is this at this moment that I need to remove the ID from the dataset of PendingOrders.
I attach some screenshots if they help you,
Hope I have explained correctly.
Flow that I'm trying to do for the refresh the information
No effects
Thank you so much!