Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver II
Resolver II

Scanner API - Dataset Users Whole Organization

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.





Community Support
Community Support

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?

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.