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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
kamini
Helper III
Helper III

How to Create an Editable Table using Power BI

Hi folks,

I have to import/Load an Excel Table to Power BI, but after Loading the Excel file, I need to be able to enter brand new information into the table columns per line of information. For example, I can load the specific User's PC information and their organization, manager, etc, but to keep track of the status of the upgrading their systems, I need to have 3-4 additional fields that I can enter Status, Date and other information per upgrading the user's PCs. 

I wasn't sure if it is doable in Power BI to publish a report or any other format that the end user can actually input information to some of the fields. 

Thank you in advance for your time.

 

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @kamini ,

 

in general Power BI is an analytics tool. They are made to analyze big amounts of data, but not to write into a data source as this brings some complexity in real life.

Why don't you just add the information in Excel?

 

Otherwise you can include a Power App into the report with the Power App visual and from there you can write back to your data source.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

View solution in original post

1 REPLY 1
selimovd
Super User
Super User

Hey @kamini ,

 

in general Power BI is an analytics tool. They are made to analyze big amounts of data, but not to write into a data source as this brings some complexity in real life.

Why don't you just add the information in Excel?

 

Otherwise you can include a Power App into the report with the Power App visual and from there you can write back to your data source.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.