Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
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:
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
User | Count |
---|---|
9 | |
2 | |
2 | |
2 | |
2 |