Forum Discussion

red_arrowhead's avatar
red_arrowhead
Helper I
5 years ago
Solved

How to have table values in certain column edited using table visualization

I have a excel sheet loaded into power BI. I want to have a visulization in the report tab in such a way that I can display some specific columns from my actual table and also can edit values in the ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    red_arrowhead Power bi accepts the data  from datasource kind of "read only" and use the data for anlysis there is no way if you update or edit any rows in power bi table it will edit the database at all

    Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


    Appreciate your Kudos, Press the thumbs up button!!👍

  • mahoneypat's avatar
    mahoneypat
    5 years ago

    To do this you would need to use PowerApps (to do the write back to your source) and use the PowerApps visual in Power BI.

    Regards,

    Pat

red_arrowhead's avatar
red_arrowhead
Helper I
5 years ago

Anonymous Thanks a lot for your reply. So, there is no way  at all possible for this? My main goal was to get an override for my data, if any manual value is required it should be inputted right away from the visulization tab which can update into the actual table. I want to have an user input tab on the visulization. Is it possible by any means?

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

To do this you would need to use PowerApps (to do the write back to your source) and use the PowerApps visual in Power BI.

Regards,

Pat

  • red_arrowhead's avatar
    red_arrowhead
    Helper I
    5 years ago

    mahoneypat Thanks for your reply. I am new to this environment. I linked it with power apps in Power BI, but how can I proceed with creating an app to take user input. Can you let me know?