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.
In regards to our Power BI issue we are having difficulty understanding the security configuration required for our customers. Let me first explain how we are setup and perhaps from explaining things from the beginning you can point out any issues you see along the way.
Solved! Go to Solution.
RLS cannot change the dataset. It can restrict the rows considered within a single dataset. RLS within Power BI is not ready for primetime yet, in my opinion. It does not even apply in a workspace where an end user has edit permissions ... like their own "My Workspace".
RLS in SSAS is much more robust and supported in Power BI. This is the route I would continue to suggest for now to utilize role-based security in Power BI reports.
Regardless of RLS in Power BI improving, the functionality is not there to support the type of parameterization of datasets that you'd like to see. PBI RLS and SSAS RLS would require a single-tenant solution.
Old post I know but I read this and thought of a solution. If you create a merged view of the data from each database either by appending each set of data in power bi or using a SQL view to merge them beforehand. Then you could use RLS to restrict the users access.
Hi,
I have to say external sharing is not currently supported with datasets that using RLS.
Please reference the “Limitations” in this article https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/.
You can also take a look at this similar case: http://community.powerbi.com/t5/Service/Is-External-sharing-possible-with-data-set-that-use-RLS/m-p/....
Best Regards
Alex
RLS cannot change the dataset. It can restrict the rows considered within a single dataset. RLS within Power BI is not ready for primetime yet, in my opinion. It does not even apply in a workspace where an end user has edit permissions ... like their own "My Workspace".
RLS in SSAS is much more robust and supported in Power BI. This is the route I would continue to suggest for now to utilize role-based security in Power BI reports.
Regardless of RLS in Power BI improving, the functionality is not there to support the type of parameterization of datasets that you'd like to see. PBI RLS and SSAS RLS would require a single-tenant solution.
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.