Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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?
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