Forum Discussion
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...
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.
Hi k_h_s ,
As suggested by others, you can create calculated table using DAX functions.but it will not give you the expected performance.the report may not work properly.the best solution to this is to load tables using SQL and create a composite model.
References:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
Thanks and Regards,
Praful