cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Re: this visual contains restricted data

I did the exact same thing as you -- removed RLS from a report that used to have it -- and now I'm also getting the error "This visual contains restricted data"

 

I tried removing the report from the app, publishing, adding it back again, and republishing, but to no avail.

 

Posting to subscribe to this thread in case anyone figures out a fix!

Highlighted
New Member

Re: this visual contains restricted data

Hi arthurholtz and Ganesan K.

 

I had this same problem today and I think I found a fix. In the workspace (online version of PowerBI, not the desktop) click the settings icon under "actions" on your Report. Then under "Export Data" select "Summarized Data" or "None" to replace the default "Summarized data and underlying data". The users with permissions should now be able to see the report visuals.

 

Hope this helps.

 

Ciaran

Highlighted
Helper I
Helper I

Re: this visual contains restricted data

Please click on the Datasets tab present in the power bi service along with that report. Check the security tab whether it has any RLS still showing. It has to show the below message if there is no RLS. Also specify the access level set for your role if you are member to that workspace.

 

RLS_Screenshot.jpg

Thanks,

Ganesan k.

Highlighted
Frequent Visitor

Re: this visual contains restricted data

I tried changing the export data settings, but no luck! 😞

 

I can confirm the Power BI service shows the informational message about RLS when I view the dataset's security, which I can only imagine means there is no RLS detected in the report.

 

One strange thing I noticed is that even after I uncheck "Included in App" for the report and republish the app, the report and source dataset still appear in the app. I'm not sure if that's related.

 

Unless someone has a better idea, I'm thinking the only course of action is to delete the report entirely and re-upload.

Highlighted
Helper I
Helper I

Re: this visual contains restricted data

Just a thought, Could you please check the manage permissions tab in the dataset and the same user has access to Read and reshare the datasets? If the user do not listed in the datasets permissions tab, he could not see the data.

 

Thanks,

Ganesan k.

Highlighted
Frequent Visitor

Re: this visual contains restricted data

Most of our users don't have pro licenses, so they're not members of the workspace. Even I get the restricted data error if I try to view the report through the app, and I'm an owner of the group!

Highlighted
Frequent Visitor

Re: this visual contains restricted data

nothing fixed it till I deleted the user out of "managed roles" from the "Managed Roles" within the power bi Desktop app.  after that I replublished and it worked.  Adding a user to RLS within the web under datasets got rid of the error but no data would show for the user.

Highlighted
New Member

Re: this visual contains restricted data


@JanusPedersen wrote:

I've have had the same issue...

 

For me the solution was to go to the RLS (Row-Level Security) settings (in the online version) on the datasets via the three "..."

 

In the RLSview you'll have to choose every single person you've shared the data with and enter their e-mail once again, and press "Add" and then "Save" in the buttom.

 

I hope this is useful for others - I've spend hours seaching for the solution...

 

Best

Janus



This actually worked for myself. I just added the user for which there were problems to all possible groups. Seems like overkill though.

Highlighted
Frequent Visitor

Re: this visual contains restricted data

Hi Folks,

 

I'm using Report Server (rarely use the cloud).  Had the same issue with the "Visual contains...yadda..."

 

Discovered that if I removed the Role I had setup in the IDE for testing, it worked fine once published.

 

Figured I'd share in case it helps anyone else.

 

Microsoft figured otherwise.  Took me a while to get logged in here again.  /sigh

 

Dave

Highlighted
Frequent Visitor

Re: this visual contains restricted data

Hi @Jaap_Olsthoorn , I am also facing the same issue. did you fix the issue? if yes pls guide me how to fix the issue.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors