topic Re: The UseRelationship() and CrossFilter() functions may not be used when querying 'fact_restarts' in DAX Commands and Tips

The UseRelationship() and CrossFilter() functions may not be used when querying 'fact_restarts'

Anonymous — Wed, 26 Apr 2023 08:41:20 GMT

Hello Team,

A user is getting below error while accessing some of the drill throughs in PowerBI dashboard in service.

We have indeed used USERELATIONSHIP function in our measures..

Can you help as it is quite urgent and business is impacted.

Re: The UseRelationship() and CrossFilter() functions may not be used when querying 'fact_restarts'

Greg_Deckler — Wed, 26 Apr 2023 15:44:29 GMT

Anonymous Could be this:

link to forum

Marco's answer:

The use of USERELATIONSHIP is not supported in security roles. 
Use ALL and FILTER manually, check the "virtual relationship" pattern here: 

http://www.daxpatterns.com/handling-different-granularities/

USERELATIONSHIP function cannot be used while querying table 'MyTable' because of the row level security defined on table 'UserSecurity' (microsoft.com)

Otherwise, need more information than what has been provided.

Re: The UseRelationship() and CrossFilter() functions may not be used when querying 'fact_restarts'

Anonymous — Fri, 05 May 2023 17:31:11 GMT

Super, thanks a lot