Forum Discussion

maserr's avatar
maserr
Icon for Helper IV rankHelper 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 c...
Need Help
collinq's avatar
collinq
Icon for Super User rankSuper 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
Icon for Helper IV rankHelper 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
    Icon for Super User rankSuper 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!

     

    • maserr's avatar
      maserr
      Icon for Helper IV rankHelper IV
      5 years ago

      Hi collinq ,

       

      in that case, the user would be still able to connect to the analysis server using Power BI Desktop, isn't it?

       

      Thanks

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi, maserr 

        People who have permission of  build/ App (build) have acess to  connect to the dataset using Power BI Desktop.
        You can go to dataset->manage permissions to check it.

         

        For your requirement ,please  follow tese steps.
        1.Unpublish current app
        2.Remove Build permission for a dataset in an app 
        3.republish app to only share dashboard and report to user : not give user any permissions for the app’s underlying dataset.

        Best Regards,
        Community Support Team _ Eason