Forum Discussion

Flo1's avatar
Flo1
Advocate I
8 months ago
Solved

Object Level Security Not Supported

Hi all, in general it is possible to create a Object-Level Security (OLS) in my Power BI Report using Tabular Editor. I am using Tabular Editor 2. To setup OLS it is neccesary to activate the unsopp...
Need Help
  • Mauro89's avatar
    Mauro89
    8 months ago

    Hi Flo1,

     

    as of my knowledge you dont need this option. At least in my cases I never actively used this.
    Check out the example here. And I also just use Tabular Editor 2 for it.

     

    Another option could be to use the new feature in MS Fabric Security with OLS, check it out here.

     

    Best regards!

    PS: If you find this post helpful consider leaving kudos or mark it as solution

ajaybabuinturi's avatar
ajaybabuinturi
Super User
8 months ago

Hi Flo1 ,

 

Yes, it is technically possible to define Object-Level Security (OLS) in a Power BI dataset using Tabular Editor 2 but only under certain conditions.


Tabular Editor 2 does not officially support all model metadata operations required for OLS.
Therefore, you must enable: File >> Preferences >> Enable unsupported features. This exposes the OLS properties so you can set them manually.

 

If unsupported features are enabled, you can:

  • Add a Role
  • Set Table Permissions = None / Read / ReadObject
  • Set Column Permissions (hide / expose)
  • Create OLS definitions in the model metadata

If done correctly, Power BI Desktop and the Power BI Service will honor your OLS rules.

 

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.