What is fast M language or DAX query for full outer join?

[sbm_tekade]

I have two tables from two different sourcesand wanted to perform full outer join on them to check mis-matches in both table and on top of that few extra columns working as indicators or flags for mis-match.

Having existing model for this but it is taking time to refresh the report manually on desktop as well as on service.

How can I overcome this situation? 

[Daryl-Lynch-Bzy]

Hi @sbm_tekade - My first thought is try an reduce the scope of the comparison to smaller sub-set.  The smaller set will be less memory intensive, so PBI Desktop or the Service can use memory more effectively.  But without a more detail it is hard to provide advice.

Can I suggest add more detail to help.  Eg what are the data sources, how big are the tables, what columns are you trying to compare.  The answer will depend a lot on the answers to the above.

Many thanks

Daryl