Skip to main content

Power BI

New

Dataflow Permissions

Vote (108) Share
Miles Cole's profile image

Miles Cole on 07 Mar 2019 02:57:43

Just like outstanding requests to assign app/workspace permission at a folder level within the app, we need to be able to give some users access to just individual dataflows without giving them access to the entire workspace that the dataflows are contained in.

Comments (12)
Miles Cole's profile image Profile Picture

27c73c9d 4cf6-ea11-a815-000d3a579c38 on 14 Sep 2020 05:55:34

RE: Dataflow Permissions

I have expanded on and refreshed this Idea in the hope that it gets more attention/traction.

You can find it here https://ideas.powerbi.com/ideas/idea/?ideaid=1112d3ef-4df6-ea11-b5d9-501ac5245825

Miles Cole's profile image Profile Picture

272ce138 d4d8-ea11-a813-000d3a579c38 on 07 Aug 2020 17:38:32

RE: Dataflow Permissions

This is my #1 need. This would greatly simplify my ability to organize dataflows by department/function across the Enterprise. Without this, the organization is much less intuitive.

PLEASE CONSIDER. PLEASE UPVOTE!

Miles Cole's profile image Profile Picture

c4aede8c ac7e-e611-80f0-5065f38a7b91 on 06 Jul 2020 00:16:57

RE: Dataflow Permissions

An additional context this comes up in is I'd like to give users the ability to consume an individual dataflow, but not the ability to delete it.
Currently when giving Contributor or Member role to a user, it also gives them the ability to delete the dataflow.
Since there is no 'recycle bin' this is going to mess up any datasets that depend on the specific GUID of the former Dataflow.

Miles Cole's profile image Profile Picture

8aa64134 aab2-476b-9618-a178d048e189 on 06 Jul 2020 00:16:12

RE: Dataflow Permissions

Yes, exactly this! I have several business-unit-wide Dataflows I want to make available to report creators, but I don't want them to have access to the Management's business-unit Reports (all in the same Premium workspace)

Miles Cole's profile image Profile Picture

59b824d2 1f95-4da2-9460-52bdbd448b5b on 06 Jul 2020 00:15:50

RE: Dataflow Permissions

We can't use data flows currently - no way I am giving users access to everything in a workspace - so they can access one dataflow. I am also not creating a new workspace for each dataflow.

Miles Cole's profile image Profile Picture

0da1d36d 58e2-4b21-8d8b-3ac45cd9a248 on 06 Jul 2020 00:12:27

RE: Dataflow Permissions

Not being able to granr permissions at the dataflow level defeats the other advantages of dataflows. We would like to have one copy of the dataflow instead of multiple copies just because of the security issue.

Miles Cole's profile image Profile Picture

99f79c10 948f-48aa-9589-49f3ee6ec535 on 06 Jul 2020 00:08:44

RE: Dataflow Permissions

I agree. We need to be able to give users build or view permission to Dataflows like we can with Datasets.  This will provide finer control on who can access what data within a Workspace without giving them the ability to create, update, or delete content within the Workspace.  This will also reduce the number of workspaces that have to be created.

Miles Cole's profile image Profile Picture

a6966d00 35c5-4f4f-b011-1f73ec2a9792 on 06 Jul 2020 00:08:09

RE: Dataflow Permissions

At the time of this comment, there is only security at the workplace scope for Dataflows. It would help to have the ability to secure at the following scopes:

1) Dataflow (model scope)
2) Dataflow Entity (table scope)
3) Entity Column
4) Entity Row

Miles Cole's profile image Profile Picture

49caf22f 2327-470c-b1e6-53b6b487fffa on 05 Jul 2020 23:56:19

RE: Dataflow Permissions

This is a requirement. Consider the following:

I am a data source owner and I want to democratize my data. I have been given a single Premium workspace and I would like to use it to triage dataflows to dataset developers spread across the organization. I create two dataflows:

1) HR DF
2) Ops DF

How do I share HR DF with HR so that the Ops folk cannot see it?

Miles Cole's profile image Profile Picture

2826746b 8215-4a3d-9ec2-66c1eaa6166e on 05 Jul 2020 23:49:58

RE: Dataflow Permissions

This has come up recently for me. I have a dataflow in my division that it would be helpful to share with another team, but I don't want to share my whole workspace with them so they can access it. Indeed, they don't even need to see the whole dataflow, just a portion of it.