Forum Discussion
User or group access limit for DATASET
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
Resident Rockstar
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
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
