0

I am trying to set the object level security of an table in my power bi service dataset to none using TMSL. Below mentioned MS doc says it could done with basic TMSL command. But it throws error saying "Data at root level is invalid"

    "roles": [
      {
        "name": "My Role",
        "description": "All allowed users to query the model",
        "modelPermission": "read",
        "tablePermissions": [
          {
            "name": "My Table",
            "metadataPermission": "none"
          }
        ]
      }
]

I also tried to put it in the alter command like below, it returns empty but still does not impact the dataset

    {
"alter": {
"object": {
"database": "dataset name",
"role":"Role Name"
},
"role":
{
"name": "Role Name",
"description": "All allowed users to query the model",
"modelPermission": "read",
"tablePermissions": [
{
"name": "Table Name",
"metadataPermission": "none"
}
]
}

}
}

https://learn.microsoft.com/en-us/analysis-services/tabular-models/object-level-security?view=asallproducts-allversions#column-level-security

Please suggest what am i missing.

Mohit Leekha
  • 61
  • 11

0 Answers0