User or group access limit for DATASET

[Anonymous]

I am aware that you can have at most 100 users or gorups in the access list for an APP.

Is there a similar limit for granting access to a dataset?

[Anonymous]

@v-chenwuz-msft  Well I was looking for a documented confirmation - it clearly states here in under considerations and limitations that APPS have the 100 users or groups limit. I was trying to confirm assigning users/groups to a DATASET had the same limit. Does your response confirm the limit for datasets?

[Burningsuit]

Hi @Anonymous 

You're right the documentation says Apps have a 100 user or group limit. The maximum an Azure AD group can have in it is 50,000. so you could have 100 groups of 50,000 members each.. well, you do the math 🙂 

That limit is simply because the list of user or group names you can enter is limited to 100 on the App user interface.

There's no limit to the number of users you can grant access to on a Dataset. I can find no documentation that confirms this, but others have asked the same question in the past, see here ..

Solved: Is there any no of user limit of concurrency of vi... - Microsoft Power BI Community

Functionally, you may experience slow response if you get to a large number of concurrent users (Large probabaly here means in the tens of thousands), espacially if you are not on a Premium Capacity, but there seems to be no limit to the number. 

Hope this helps

Stuart

[Anonymous]

@Burningsuit  Thanks for the reponse. I guess I am not being clear. The USER limit is not my concern - my concern is the limit of 100 USERS/GROUPS for a dataset.  This limit is clearly documented for APPS - I wanted to confirm if this same limit existed for DATASETS.  It seems you are saying that, YES, you can only include 100 USERS/GROUPS on dataset permissions (limited by UI) same as documented for APPS.

[Burningsuit]

Hi @Anonymous 

No, the sharing mechanism is not the same for Datasets as it is for Apps.

An App has a list of users or groups it is shared with, entered when the app is created or managed. That list has a user interface limit of 100 items, but as those items can be groups that does not limit the numbers that an App can be shared with. You simply create large groups and share it with those groups.

Sharing access to a Dataset can be done in many ways, for different reasons.

Sharing access to a Report, grants the recipient access to the database, with optional "build" rights. A link to share access can be generated that can be used by the entire organisation. You can share with groups and you can share with individuals.  You can also share a Dataset directly. In all cases the user interface is different from apps, you can enter groups, user names, or generate links and this can be done multiple times.

Unless you have a Premium Capacity licence, I would expect the limit is the number of licences you have rather than any theoretical number you can share with.

Out of interest, why does this matter to you ? Have you come up against a limit or do you have a large number (10,000+ ) to share with ?

Hope this helps

Stuart

[Anonymous]

@Burningsuit Why does it matter...? I have a dataset in a centralized workspace that is used by reports in multiple APPS. The dataset permission list was approaching 100 - I was aware of the documented users/groups limit for an APP and I was trying to confirm if there was a limit on DATASET users/groups.  I appreciate your responses - honestly, I have not heard a definitive yes or no to my question - but I will manage the APP and DATASET permissions with the APP limit just for consistency.

[v-chenwuz-msft]

Hi @Anonymous 

The app you mentioned has a 100 user limit, it's just that you can only drop 100 users or groups in its share list, it doesn't mean 100 users.

I found a few articles about its limitations.

“At most, you can share with 100 users or groups in a single share action. However, you can give more than 500 users access to an item.”

Dateset also has such a shared access list, so dateset has such a restriction. What do you think?

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.