Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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!
Proud to be a Datanaut!
Private message me for consulting or training needs.
Thanks for your response. What do you mean with sharing the app with no ability to get to the dashboard?
thanks
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!
Proud to be a Datanaut!
Private message me for consulting or training needs.
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
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
Dear Eason,
The user already do not have these permissions, but please do not forget that my connection is Live Connection so the user is in a role in the cube in order to access to data (in order to see data in the application and not to see the reports empty)
Thanks in advance
Hi , @maserr
If you still have no idea about that, you can open a support ticket with MSFT to seek technical support , they will may better suggestions.
Best Regards,
Community Support Team _ Eason
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.