Forum Discussion

Hado94's avatar
Hado94
Frequent Visitor
3 years ago
Solved

Editing created table value with a button/power app

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 lik...
Need Help
  • TomMartens's avatar
    TomMartens
    3 years ago

    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

TomMartens's avatar
TomMartens
Super User
3 years ago

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