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.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous Great questions. A few weeks ago I tried to solve this for myself but was not able to get anywhere. Since there is no way to detect the user doesn't have permission on an object, you cannot control what to do when there is no permission. At this point, we don't have a choice and live with out of a box error messages which is not very user-friendly.

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    parry2k  Thank you for you response.  Is there any other alternative to achieve this. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      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.