Scanner API - Dataset Users Whole Organization

[m-colbert]

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

[v-chenwuz-msft]

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.

[m-colbert]

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?