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.
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 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.