Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to show hide a visual when the visual error occurs

Hi Team,   We have OLS(object level security) implimented in our report and when an user who doesnt have access to certain object logs in, the visual will show an error message like below.   Inst...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I found an alternative solution for this.  below is what i did.

    1.  I called the same AD group another time and adding into the datasource and creating relationship (getdata --> AD group). this is the same AD group from where the OLS is getting applied

    2.  Created a DAX measure in my table to check if the user from table1 is available in AD group table, if yes, give color "#FFFFFF00" else "red". 

    3.  Added a rectangle shape on top of the visual which gives error when OLS is applied. 

    4.  For this rectangle shape I added the background with function... and added this dax there which changes the color based on the dax.

     

    Hope that helps for those looking for an alternative.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

You can not only hide tables and columns but also completely hide the model metadata, so your secured tables and columns are obscured in the field list when using reporting tools like Excel or Power BI. A user without permissions cannot access secured metadata objects via DAX or any other method. To viewers that don’t have the requisite permission, the secured tables or columns simply do not exist.

Please refer to the following blog which explains the relevant steps in detail.

https://powerbi.microsoft.com/en-us/blog/object-level-security-ols-now-available-for-public-preview-in-power-bi-premium/

 

Best Regards

Community Support Team _ Ailsa Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.