Problems with certain roles not showing data

[molivR]

Hi,

I have a problem with certain roles... I have 64 roles assigned of which 16 are not working well, all within the same report. I asign the role with the proper column name which I use as a filter, when I click on the button next to the role assignation "See role as" which lets me see the report from a specific role it shows no data from any table... I don't understand why while the other roles can be seen just fine and have data.

I noticed this when I published my report online, I gave permissions in the RSL security section and again, everything can be seen fine except *those* roles, I don't get what I'm doing differently from the other 50+ roles that show the data just fine.

Of course the filters work just fine in desktop and show everything, it stops displaying after I assign the role and try to see it from that role. Any ideas what could be the problem?

Seeing the report as other roles:

1) I can see it in the filter

2) I can see the data

Seeing it with the problematic roles:

1) it doesn't even appear in the filter

2) no data shown

The roles are assigned exactly the same for both.

--------------------

UPDATE: the issue was that all the tables are connected through the filter column but for these roles they didn't have data in one of the tables (which was okay) so I had to fill them with 0s to make it work.

[Anonymous]

Hi @molivR 

Thank you very much for your solution. I believe it will be of great help to others who encounter similar issues!

Best Regards,

Jayleny

[parry2k]

@molivR sorry it is a bit hard to follow, I hope someone else can help. good luck!

[molivR · Accepted solution]

I updated with the solution: the issue was that all the tables are connected through the filter column but for these roles they didn't have data in one of the tables (which was correct) so I had to fill them with 0s to make it work.

[parry2k]

@molivR Based on the post, it is very hard to figure out, It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.

[molivR]

Yes thank you, I have added screenshots I believe it will be difficult to share the report... if it's possible to guess what could be the problem... ☹️