We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hello,
I have been messing with this for weeks now.
I have a dynamic table that refreshes on a daily basis with parameters like Project ID, Project Name and Assignee.
Now I want to add 2 additional columns (Due Date & Comment) that I can manually edit.
My unique Key is the Project ID - so when there are rows added or the Assignee changes, the due date & comment should
Power BI really isn't meant to be used for entering data. But, you have a couple options:
1) Just add the additional columns and rows in the source.
2) Create a new table in Power BI with "Enter Data" and manually enter data with Project ID, Due Date, and Comment. Then append this to your source table. And republish the report.
3) If you're wanting a report consumer to be able to enter data and have that reflected in the report, you can create a Power App that updates the source with the entered data. Use the Power Apps visual in Power BI so the consumer has a place to enter the data.
I'm looking for instructions on your third item:
Basically: they see the row, and click on it (maybe select it from the power apps list) and enter the comment - save and the table is getting refreshed.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 38 | |
| 33 | |
| 15 | |
| 15 |
| User | Count |
|---|---|
| 64 | |
| 63 | |
| 37 | |
| 36 | |
| 22 |