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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.