Forum Discussion
Helper IIIPower BI Scanner API: RLS Information
Not sure if its updated recently but I can see roles without members in our PowerBI scans.
Something like -
"roles": [
{
"modelPermission": "Read",
"name": "RoleName",
"tablePermissions": [
{
"filterExpression": "<my filter condition>",
"name": "TablePermissionName"
}
]
},
{
"modelPermission": "Read",
"name": "New role"
}]
One note, we are scanning with lineage, datasetSchema and datasetExpressions parameters as true.
Helper IIIHi DallasBaba
That does not help, sorry. The article does only explain how to access the Scanner API Call in general. I asked a very specific question.
Not sure if its updated recently but I can see roles without members in our PowerBI scans.
Something like -
"roles": [
{
"modelPermission": "Read",
"name": "RoleName",
"tablePermissions": [
{
"filterExpression": "<my filter condition>",
"name": "TablePermissionName"
}
]
},
{
"modelPermission": "Read",
"name": "New role"
}
]
One note, we are scanning with lineage, datasetSchema and datasetExpressions parameters as true.
- IMett
Hi DAC15
Thanks for your reply, that was very helpful. Then I probably have some kind of ETL mistake on my side, i will double-check that.
I am also using all paramters for the scan.👍I think you may want to check a step where you are flattening this JSON data. While getting lower level of data e.g. in Roles --> members hierarchy, if you query for members, that query might not return those roles without members.