Forum Discussion

k_h_s's avatar
k_h_s
Frequent Visitor
7 months ago
Solved

Issue with left join using measures

I have build permission on dataset, hence I can not create calculated tables or columns on the model.  I need to join two tables using left join to create the output. My permission can not be upgrade...
Need Help
Show and Tell
  • sarahlns's avatar
    sarahlns
    7 months ago

    With Build permission only, the only viable option is using virtual tables inside measures.
    By combining TOPN (ROW_NUMBER), NATURALLEFTOUTERJOIN, and TREATAS, it is possible to fully replicate complex SQL joins and window functions without modifying the semantic model or Power Query, and while respecting RLS.

v-hjannapu's avatar
v-hjannapu
Community Support
7 months ago

Hi k_h_s,

I would also take a moment to thank sarahlns  , alish_b  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.

  • v-hjannapu's avatar
    v-hjannapu
    Community Support
    7 months ago

    Hi k_h_s,
    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


    Regards,
    Community Support Team.