Forum Discussion
Post ProdigyHow to get merged table data to refresh?
Most Valuable ProfessionalHey wpf_ ,
that's a good question. Did you activate the "Assume Referential Integrity" setting?:
Assume referential integrity setting in Power BI Desktop - Power BI | Microsoft Docs
Post Prodigy
The merged table actually does not have any relationships with any other table so "Assume Referential Integrity" is not checked. Should it have a relationship with the two tables that the data is from?
v-kelly-msftCommunity Support
Hi wpf_ ,
Did you try unchecking "Enable parallel loading of tables" under Options, Data Load?
Check the similar thread below:
https://community.powerbi.com/t5/Desktop/ERROR-WHEN-REFRESHING-DATA-DUE-TO-MERGE/m-p/384249
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
- wpf_
Yes i tried that. If I need to get data by first doing a search in one table first via the summarize function in a measure, then using the result of that to get data from a second table. Would it be faster if I do it like this or would it be faster to join these two tables and only load it to memory once? BUt i noticed when joining columns from two seperate tables, it takes time to do the join i suppose?