RLS Error in Shared Dataset

Hi Syndicate_Admin ,

There are a few possible reasons why RLS might affect only one of your reports and not the rest:

• You might have accidentally created a role with a filter expression in the Manage roles dialog box in Power BI Desktop. To check this, you can open your report file (.pbix) and go to the Modeling tab and click Manage roles. If you see any roles defined there, you can select them and delete them if you don’t need them.
• You might have enabled dynamic security by using the username () or userprincipalname () DAX functions in your data model. These functions return the current user’s identity and can be used to filter data based on user attributes. To check this, you can open your report file (.pbix) and go to the Data view and look for any columns or measures that use these functions. If you find any, you can remove them or modify them as needed.
• You might have published your report to a workspace where RLS is configured in the Power BI service. This can override the RLS settings in your Power BI Desktop file. To check this, you can go to the Power BI service and open your workspace. Then, go to the Datasets tab and find your dataset. Click the More options (…) button and select Security. If you see any roles or users assigned there, you can remove them or modify them as needed.
• To disable RLS completely, you need to make sure that there are no roles or filters defined in your Power BI Desktop file or in the Power BI service for your dataset. You can follow the steps above to check and remove any RLS settings that might exist.

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

How to Remove Row Level Security in Power BI - Zebra BI

Solved: Use DAX to ignore RLS for specific aggregate measu... - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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