Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

this visual contains restricted data

Hey guys & gals,   I've been experiencing some issues sharing an app with one of my colleagues today. He has access to the app, and is able to view it, but all the content is missing behind errors....
Need Help
C4YNelis's avatar
C4YNelis
Advocate III
5 years ago

Just in case this still helps someone,

 

I too got the same error (this visual contains restricted data) for all visuals. For me the problem was that all the RLS roles that I had defined a long time ago for completely different reports, were kind of copied to this new report. I'm calling them ghost roles, since there were no attached rules whatsoever, so they should not have had any impact.

 

Previously I've published many different reports, which were no different from this one and which worked fine so far. The one difference with this report however is that while normally I only use a MySQL database as a source, this time I had added a new on-premises source (a folder containing (subfolders containing) .XML files). This folder was added to the gateway and my guess is that this somehow interfered with the RLS roles, even though they were empty.

 

The solution was a simple one though, just delete all the roles in Power BI Desktop and republish.

 

Cheers,

Niels