The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.