role level security error

[Anonymous]

Hi all, 

I have sucessfully implement RLS to my report and i have since made another report but i receive this error message when i try to test "view as roles". I cannot find out what is happening??? My datasource is an excel file 

[v-alq-msft]

Hi, @Anonymous 

To implement RLS, you need to define roles and rules in Power BI Desktop. When you publish to Power BI, it also publishes the role definitions.  You assign users in the Power BI service. You can enable dynamic security within Power BI Desktop by making use of the username() or userprincipalname() DAX functions and having the proper relationships configured. 

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.

As for the error message, It is said that you used DirectQuery. If you're importing data into your Power BI dataset, the security roles in your data source aren't used. In this case, you should define RLS to enforce security rules for users who connect in Power BI. If you're using DirectQuery, the security roles in your data source are used. When a user opens a report Power BI sends a query to the underlying data source, which applies security rules to the data based on the user's credentials. Please check whether the user has access to the data source.

For further information, please refer to the following link. It may help.

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous what is the error message, share some details. I have couple of blogs on RLS, may be that can help to identify the issue.

You can find these here.

[Anonymous]

[dethompson97]

What is the error messages?  I don't see anything in your post.

Thanks!

Dawn