Forum Discussion

maserr's avatar
maserr
Helper IV
5 years ago

Avoid acces to cube

Hi all,

 

I am trying to build applications in order to satisfy certaing role restrictions. I am managing how to achieve it but I found that using Live Connection with the tabular cube every user could log in into Power BI Desktop and see every table of the cube, even unhide them or edit a report on Power BI Service and see the cube. I am not able to apply RLS because I need global measures so if I filter data these measures would not be correct. 

 

How I could avoid the user to see all the cube?

 

Thanks in advance

Need Help

7 Replies

  • collinq's avatar
    collinq
    Super User
    5 years ago

    Hi maserr ,

     

    You would have to change your datasource.  If you datasource is open to everybody then you can't really lock it down.  If you can't lock it down with RLS I would suggest that you break up the report yourself into the multiple sections.

    OR, you could just share the APP only with no ability for the individual to get to the dashboard or report and definitely not the underlying data.

    I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

    • maserr's avatar
      maserr
      Helper IV
      5 years ago

      Thanks for your response. What do you mean with sharing the app with no ability to get to the dashboard?

       

      thanks

      • collinq's avatar
        collinq
        Super User
        5 years ago

        HI maserr ,

         

        I should have been a bit more precise - what I mean is that when you share the app, do not give them permissions.  I am specifically referring to these settings that should be off:

        Allow all users to connect to the app's underlying datasets using the Build permission.
        Allow users to make a copy of the reports in this app.
        Allow users to share the app and the app's underlying datasets using the share permission.

        I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!