I create a report with 2 tab/sheets. User can change what they want to see. First tab is the summary second is the details. The second tab has a security rules, that I created in the desktop version and I link the users to this roles in the online version:dataset security options. Its working well, A user only see the A related details B the B related details so its ok. Everybody can see the summary (first page)
I share the report to a new user and he is not able to see anything. he has the following error: the visual contains restricted data. In the detailed tab, that is inline with my expectations however I don’t know why he is not able to see the summary? The summary there is no roles/security settings should everybody see it.
Any advice how can I fix it? The new user only need to see the summary tab, not the details
my report has 2 data source 1 is for the summary and 2 is for the details. there is no connection with this 2 data source. and in the desktop if I choose role A in the details I only can see the A related items, but I can see everything in the summary