Forum Discussion
In Excel Via Get Data From Power BI Dataset
Hi gissah ，
It seems likely to me that you have RLS permissions configured in your report. What you are describing is entirely consistent with RLS, where users with edit and above permissions on a dataset have access to all data in the report when using RLS. Contributors, on the other hand, have edit access to the report.
Best Regards
Lucien
Hi gissah ,
You can configure the RLS in Power BI so that they can only see the data within the permissions and not all of the data in the report.
refer:
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
The current limitations for row-level security on cloud models are as follows:
- If you previously defined roles and rules in the Power BI service, you must re-create them in Power BI Desktop.
- You can define RLS only on the datasets created with Power BI Desktop. If you want to enable RLS for datasets created with Excel, you must convert your files into Power BI Desktop (PBIX) files first. Learn more.
- Service principals cannot be added to an RLS role. Accordingly, RLS won’t be applied for apps using a service principal as the final effective identity.
- Only Import and DirectQuery connections are supported. Live connections to Analysis Services are handled in the on-premises model.
- The Test as role/View as role feature doesn't work for DirectQuery models with Single Sign-On (SSO) enabled.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
I did not try this option, what I did was increase the user permission to contributor from viewer and it worked.
Hi gissah ，
It seems likely to me that you have RLS permissions configured in your report. What you are describing is entirely consistent with RLS, where users with edit and above permissions on a dataset have access to all data in the report when using RLS. Contributors, on the other hand, have edit access to the report.
Best Regards
Lucien