Editing created table value with a button/power app

[Hado94]

Hi there, i am kind of new to power bi and its features so bear with me.
I have a project that prompted me to create an aggregation table in order to filtre through data from two seperate tables like the image below, i have several vending machines and each one have a stock of a number of beverages.
So each line in the table represents the vending machine id, beverage brand, the sold amount, price, max stock, nb of units left ...

I have the unitsleft column that calculate the remaining items in stock by deducting the sold units from the max stock.
So far so good i have my visuals set to show each vending machine and its current stock.

What i want to do now is to create a function that the user can use/press that takes as arguments the vending machine ID and beverage type and set its units left value in the table to the default of maxstock ( to show that this machine is restocked).

I have made some research about it online but so far, the only viable options i could find was with power apps, but the problem is it wouldnt take a power bi created table as a data source, so if anyone got a more begineer friendly approch to how i can make this happen or help me figure out how to go from there.

[Hado94]

Well i waited for another input on the subject but it seems no one could help with it.
Marking it as solved tho.

[TomMartens · Accepted solution]

Hey @Hado94 ,

unfortunately what you are looking for is not possible. The reason for this that tables are not meant for being edited.

No matter if you are creating or composing tables using Power Query or DAX, the idea is that theses tables are created on top of transactions or events. These transactions/events can not be triggered from inside Power BI, the idea of Power BI is to analyze data that is generated by different processes.

Another idea could be to create three Power Automate buttons, whenever one button is his, a record is written to a Sharepoint list that marks the re-stocking of the vending machine. Of course, you have to make sure that the Power BI dataset will pcik up the new data (data refresh).

All this may seem that it is complicated, as it is not simple (e.g. like Excel) to enter a value, maybe sometimes it is, but I'm happy, that users are not able to change data by the click of a button. Power BI is not Excel, and Power BI is Access, two great applications but they are not build to tackle the same challenges.

Regards,

Tom