a. If a user updates a data input column in reading mode and closes the report, will the latest data be available when reopening?
Yes. Plan captures changes made to data input columns and stores them in the backend database. This works in both reading and edit modes. When the report is reopened, Plan retrieves the latest values and loads the report with updated data.
b. How does row-level security (RLS) work in Plan?
Plan respects the RLS defined in the original Power BI dataset. The Planning sheet displays only the rows that the user is allowed to see. RLS in Power BI applies to users with Viewer access in the workspace.
c. How does Writeback work with RLS?
Plan writes back only the rows visible to the user. If a user can see a limited set of dimension categories based on RLS, only those rows are written back. You can write back only the data visible in the Planning sheet.
d. How is data stored when multiple users perform Writeback? When are rows overwritten or appended?
Plan processes writeback operations sequentially. During writeback, Plan compares incoming rows with existing rows in the destination. If all dimension columns and values match, Plan overwrites the existing row. However, if you would prefer Plan not to overwrite rows during writeback commits, select Writeback only changes/Delta writeback as the writeback type. Under this mode, Plan retains previous values.
