User to enter data into Power Bi Report?

[1up]

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

[Adamboer]

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.

[1up]

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.

[mariussve1]

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