Forum Discussion
Dataflow role access
Hello toettoet
apologies for confusion
I meant reports in My Workspace can be shared, but it is not recommended for organizational purposes due to governance and collaboration limitations.
Build permissions are for datasetFor dataflows, there is no direct Build permission setting as of now. Users must rely on workspace roles like Viewer, Contributor, or Member for access
hope this helps and clarify the confusion
Hello toettoet
Viewer Role and Report Sharing:
• A Viewer can connect to a dataflow and create reports in Power BI Desktop.
• Reports published to personal workspaces cannot be directly shared. Sharing requires publishing to a shared workspace or exporting.
2. Exporting Data from Reports:
• Users need Build permission on the dataset to export underlying data.
• Without Build permission, they can only export summarized data if allowed by the admin or report creator.
3. Pulling Dataflows into Excel:
• Viewer role users typically cannot pull dataflows into Excel unless granted additional permissions (e.g., Build).
• Admins, Members, or Contributors can use tools like Excel to consume dataflows.
Recommendations:
• Use Row-Level Security (RLS) and restrict Build permissions.
• Disable export options for sensitive reports.
• Limit Viewer role access and monitor permissions regularly.