User can select value from dropdown and update table

[adityavighne]

Hi Team

I'm looking for option where user can select value from dropdown and select value for that table.

[Arul · Accepted solution]

@adityavighne ,

Since Power BI is a SAAS solution we can't add/edit/delete the data directly from Power BI. But you can use Power Apps in Power BI to write back to the source.

Please refer this video - https://www.youtube.com/watch?v=5y2jJyH4Eu0

[Anonymous · Accepted solution]

Thanks for the reply from @Arul , please allow me to provide another insight:

Hi @adityavighne ,

According to your description, when clicking on the refresh button in powerbi, you can synchronize the updated results in the excel sheet.

But changing the status directly in powerbi can only be done by creating a filter condition in the formula.

status_ =
SWITCH ( SELECTEDVALUE ( Sheet1[Name] ), "A", "yes", "B", "no", "yes" )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[adityavighne]

@Arul I have excel connected to power bi. Now i want to give option to user so they can change status of that contact in Power BI. for example staus for A is 'Yes' but tomorrow if user want to change from Yes to 'No' then he can make those changes in Power BI.

[Arul · Accepted solution]

@adityavighne ,

Since Power BI is a SAAS solution we can't add/edit/delete the data directly from Power BI. But you can use Power Apps in Power BI to write back to the source.

Please refer this video - https://www.youtube.com/watch?v=5y2jJyH4Eu0

[Idrissshatila]

I think he means that the user want to change the data of the data source in power bi itself, then give him access to the excel.

[Arul]

@adityavighne ,

Your ask is not clear to me. Could you explain it more in detail?