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

See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap

Reply
1up
Resolver I
Resolver I

User to enter data into Power Bi Report?

Hello, these days, is there any functionality within Power Bi for users of a report to enter data?


Consider below example where field Customer Number would be pre-populated with data, while the Sales field would hold no data.

Would it be possible to for example create a table where customer numbers are shown in one column, and for the user to manually enter Sales data in the otherwise empty Sales data column fields? Or other ways to achieve it?

 

Table: Customer

Field 1: Customer Number

Field 2: Sales 2022

 

Customer Number   Sales 2022

12345                       [User can enter any number they like]

12346                       [User can enter any number they like]

65432                       [User can enter any number they like]

 

The functionality needed is for the user to add their own data for that session, and for the data to be able to be used by the report, doing calculations with measures, possible to summarize, all standard functionality just as if the data would be have been part of the model.

 

Thanks for help,

 

//Daniel

3 REPLIES 3
Adamboer
Responsive Resident
Responsive Resident

Yes, it is possible to create a table where users can manually enter data in Power BI. Power BI allows users to create data entry forms that allow users to enter data and update tables in real-time.

Here's how you can achieve this:

  1. Create a table with the necessary columns (e.g., Customer Number and Sales 2022).
  2. Create a new page in your report and add a table visual to it.
  3. Add the necessary fields to the table visual (e.g., Customer Number and Sales 2022).
  4. Under the modeling tab, click on the "New Measure" button.
  5. Enter the formula for the measure you want to create (e.g., Total Sales = SUM('Customer'[Sales 2022])).
  6. Under the "Visualizations" pane, click on the "Fields" button and select the "New Quick Measure" option.
  7. Select the "SUMX" aggregation function and drag the "Customer Number" field to the "Values" field well.
  8. Drag the newly created measure to the "Values" field well as well.
  9. Your table visual should now show the total sales for each customer.
  10. Publish your report to Power BI service and share it with your users.

Your users can now enter their own data into the Sales 2022 column, and the Total Sales measure will update accordingly. The entered data will be saved in the report, and you can use it for further calculations or analysis.

Hi Adam, reading the step by step instructions, this solution seem to focus on the users that have access to the source data and can update them. How do you see it?

I am trying to locate a solution for report viewers to enter their custom data directly into an existing report visual or equivalent, which would just be stored for that particular session basically.

Is this something chat gpt answers? Maybe Im wrong, but I got a feeling that you just pasted a answer from chat gpt.


Br
Marius
BI Fabrikken
www.bifabrikken.no

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.