The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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