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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi ,

 

I am facing the same issue. I have removed all the RLS which was there earlier and also enabled the access as mentioned in your screenshot for users. Even after that i am getting the same error saying we do not have access to view the backend data.

 

Do you have any other solution for this issue?

 

 

Thanks,

Ganesan k.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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.

       

      Thanks,

      Ganesan k.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.

    • Ciaran_3991's avatar
      Ciaran_3991
      New Member
      7 years ago

      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