Forum Discussion
User Relationship not working in Service
Im not sure what is going on here
these measures are working in desktop but not the service, it is a composite model with direct query/mport and both measures use the "USERELATIONSHIP" function.
2 Replies
Are you aware of all the limitations of using USERELATIONSHIP() function?
for example if your model has RLS implemented then USERELATIONSHIP() wont work, similarly there are few other limitations, you can read them here
https://dax.guide/userelationship/
In such scenarios consider using TREATS() function to create a virtual relationship
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
so it doesnt work in direct query reports?
