Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayKnown issue - Reports that use functions with RLS don't work
You can define row-level security (RLS) for a table that contains measures. USERELATIONSHIP() and CROSSFILTER() functions can't be used in the measures. A change was recently made to enforce this requirement.
Status: Open
Product Experience: Power BI
When viewing a report, you see an error message. The error message is similar to: "Error fetching data for this Visual. The UseRelationship() and Crossfilter() functions may not be used when querying <dataset> because it is constrained by row level security" or "The USERELATIONSHIP() and CROSSFILTER() functions may not be used when querying 'T' because it is constrained by row-level security."
The change is to enforce a security requirement. To prevent your reports from failing, you can remove USERELATIONSHIP() and CROSSFILTER() from your measures. Alternatively, you can modify the relationships using recommendations for RLS models.
Additional resources
Training
Module
Implement row-level security - Training
Row-level security (RLS) allows you to create a single or a set of reports that targets data for a specific user. In this module, you'll learn how to implement RLS by using either a static or dynamic method and how Microsoft Power BI simplifies testing RLS in Power BI Desktop and Power BI service.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.