Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

USERELATIONSHIP issues between desktop and service

Hi everyone,  I am struggling with an issues using the function USERELATIONSHIP. My example is pretty easy to understand :  I have a table that is related with several dates to my calendar, inte...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    Hi Anonymous,

    Hope you are doing well
    Thanks for connecting with the Microsoft Fabric Community Forum.


    Thank you Idrissshatila for identifying the issue on the thread.

    The product team will address and resolve this issue as soon as possible.
    Please keep track of it so you will be notified once it is resolved.

    If this post clears your doubt, please give us Kudos and consider marking Accepting it as a solution to guide other members in finding it more easily.

     

    Thank you have a great day a head.

FedeMosquera's avatar
FedeMosquera
Frequent Visitor
1 year ago

Hi everybody,

 

What we did in my company with a report was to use TREATAS instead. There were about 40 measures that needed to be changed from USERELATIONSHIP to TREATAS, for which I used Microsoft Copilot with the following prompt "I'm going to give you DAX measures that have the USERELATIONSHIP and I want you to give back the same DAX measure but using TREATAS instead".

 

I also erased all the inactive relationships I had between the Dimension table with the RLS and the fact tables, as they are not needed using TREATAS.

 

We couldn't wait for Microsoft to correct this, so this method worked for us. Hope this helps.

 

Regards

Federico