Forum Discussion

PetrusJKruger's avatar
PetrusJKruger
Frequent Visitor
8 years ago
Solved

RLS Embedded Reports Created from a Specific Computer "Cannot Display the Visual"

Good day Community,

I'm experiencing a very strange set of occurances.

Up until about three weeks ago, reports that I created with RLS security filters worked fine. This changed quite suddenly when various users began to get a "Cannot display this visual" error message for all visuals in the reports. However, this is only the case for reports built on my PC. Reports built by two of my collegues display as normal.

I have, in fact, rebuilt one of the simpler reports in almost exactly the same way as my collegue and embedded them side by side - his works, mine doesn't.


Some assistance would be greatly appreciated.

Edit: Since posting this, I have also rebuilt my collegue's report on a virtual machine on one of our reporting services. Indeed, that reports works fine too. 

Kind regards,
Petrus

 

  • After much deliberation, I believe I have found the solution to my own problem.

    It turns out that the embed token defined a role by a specific name i.e. "user".

    When I began to apply RLS to other user attributes, I renamed the role within my pbix file i.e. "user_workplace".

    My collegues, happened to just reuse the "user" role by default, and out of sheer luck and laziness, I did the same when I rebuilt the report on the VM.

1 Reply

  • PetrusJKruger's avatar
    PetrusJKruger
    Frequent Visitor

    After much deliberation, I believe I have found the solution to my own problem.

    It turns out that the embed token defined a role by a specific name i.e. "user".

    When I began to apply RLS to other user attributes, I renamed the role within my pbix file i.e. "user_workplace".

    My collegues, happened to just reuse the "user" role by default, and out of sheer luck and laziness, I did the same when I rebuilt the report on the VM.