Forum Discussion
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.
Instead of this error, I would like to hide it or show a message "You dont have necessary permissions to view this data".
Any help, how can i achieve this?
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.
5 Replies
- parry2k
Super User
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.⚡
parry2k Thank you for you response. Is there any other alternative to achieve this.
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
Anonymous unfortunately not at this point. I think there are some ideas on this on the ideas forum. Go and vote for the idea.
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.⚡
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.
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.
