Forum Discussion
Solved
Translytical task flow — Viewer role cannot trigger data function button, Member role works
Hi all, I've built a translytical task flow into a Power BI report (comment + flag write-back via Fabric User Data Functions) and I'm stuck on a permissions issue that I can't explain. Hoping someon...
Thank you for your responses. I have contacted Micorosft Suppoert and with their help I was able to solve the permission issues. The following has to be applied:
For a Viewer to successfully perform a writeback via a User Data Function, the following access must be granted in addition to report access:
- Consumers must be added as Viewers to the workspace(s) where the report resides, and to the workspace(s) where the database and the User Data Function reside (if different).
- They need Build permission at item level on the semantic model.
- They need Read, Write and Execute permissions at item level on the User Data Function.
- They need Read and ReadData permissions at item level on the DWH (Data Warehouse) where the writeback tables are located.
Thank you for your responses. I have contacted Micorosft Suppoert and with their help I was able to solve the permission issues. The following has to be applied:
For a Viewer to successfully perform a writeback via a User Data Function, the following access must be granted in addition to report access:
- Consumers must be added as Viewers to the workspace(s) where the report resides, and to the workspace(s) where the database and the User Data Function reside (if different).
- They need Build permission at item level on the semantic model.
- They need Read, Write and Execute permissions at item level on the User Data Function.
- They need Read and ReadData permissions at item level on the DWH (Data Warehouse) where the writeback tables are located.