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.
Hi everyone,
I am trying to obtain information about Row Level Security configuration from the Scanner API, as described here:
https://learn.microsoft.com/de-de/rest/api/power-bi/admin/workspace-info-get-scan-result
The scan actually works, however concerning RLS Usage I have noticed, that roles names are only returned when there is at least one member assigned to the role. Otherwise I get a null value in the "roles" column for the whole dataset, even for those where I know and actually see that there are RLS roles configured.
Unfortunately this is exactly the case which I want to monitor: whether there are any configured roles without any users assigned to them which is usually a mistake.
Does anyone experience the same behaviour? Is the issue maybe known to the product team?
Solved! Go to Solution.
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.
Hi @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.
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.
@IMett I am not sure if anyone else has experienced the same behavior.
However, I found a Microsoft Learn article that explains how metadata scanning facilitates governance over your organization’s Power BI data by making it possible to quickly catalog and report on all the metadata of your organization’s Power BI artifacts.
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 |
---|---|
13 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
25 | |
3 | |
2 | |
2 | |
2 |