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

[charurock]

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.

@Greg_Deckler  

@tamerj1 

@johnt75 

@Jihwan_Kim 

@FreemanZ 

@amitchandak 

[charurock]

Super, thanks a lot

[Greg_Deckler]

@charurock 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 secu...

Otherwise, need more information than what has been provided.