Forum Discussion

thegeneral1's avatar
thegeneral1
Regular Visitor
5 years ago
Solved

User input data from Dropdown

Hi All,          I have created a simple power BI data only table - but i need another column that a user can either select "Keep" or "Remove" using a dropdown, for each row. These values would also...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, thegeneral1 

    Power bi did not include any writeback features, you can't direct save changes and writeback these result.

    For your requirement, you can consider creating a PowerApp for input and submit operation.

    Power BI enables data insights and better decision-making, while Power Apps enables everyone to build and use apps that connect to business data. Using the Power Apps visual, you can pass context-aware data to a canvas app, which updates in real time as you make changes to your report. 

     

    Related documents:

    PowerApp_control-drop-down 

    PowerApps-custom-visual 

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Super User
5 years ago

thegeneral1 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

  • thegeneral1's avatar
    thegeneral1
    Regular Visitor
    5 years ago

    Hi

    Very simple example below

     

    Col A:D is the data coming from Direct Query DB.

    Col E2 is blank but with selectable dropdowns ie. Keep or Remove.

     

    A User that visits the power BI table can input whether to Keep or Remove

     

    Hope this is clearer??

     

    Thanks