Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm pulling worksapces scans using the Scanner API to load meta data into SQL. While writing a simple merge I got an unexpected condition where the same dataset id and same graph id have two differenet access rights. as indicated by the "MERGE statement attempted to UPDATE or DELETE the same row more than once" error.
This happens only when the user display name is "Whole Organization", not for an actual user, group or service prinicipal. It's not on every workspace or every dataset, just some. It has the princiaplType of None. However, when reviewing permissions on the dataset in the service, Whole Organization is never displayed. I'd like to understand how it got there and how I can remove it.
Thanks
Hi @m-colbert ,
princiaplType none is Used for whole organization level access.
Datasets - Get Dataset Users In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Maybe you can delete it by rest api
Groups - Delete User In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs
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.
More of the issue is why is this only on some workspaces, how did it get there and how can the service report more than one access level for the same object/group?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |