Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

RLS not working with SERELATIONSHIP or CROSSFILTER

Measures written using USERELATIONSHIP or CROSSFILTER do not work with RLS.

Power BI gives a message saying "UseRelationship() and CrossFilter() functions are not available in this context".

Obviously this is extremely annoying because it's very common, in complex datasets, to have inactive relationships, and therefore to use USERELATIONSHIP or CROSSFILTER. This is especially the case in medium-large organizations, where RLS ia a great help to segregate data.
Therefore, I strongly believe that RLS should work smoothly with inactive relationship.


Thank you

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @marcofavaleD360

 

Is it possible for you to share a pbix file with some dummy data? If it is, you can upload it to your OneDrive and paste the share link here. 

 

Best Regards,
Qiuyun Yu