Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
red_arrowhead
Helper I
Helper I

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 visulization which will also auto update in my actual database. How to look forward to this problem?

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

@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!!👍

View solution in original post

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

4 REPLIES 4
Anonymous
Not applicable

@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!!👍

@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?

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


@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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors