User Profile
Artofdax
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Table.selectrows with list.contains loading issue
Hi I need help with my filter I’ve filter values in Table1 and creating a reference table. I then converted this table to a key ID list. And apply as filter to table2 using Table.selectrows( pervious step, each list.contains(list.buffer(list.distinct (mykeylist)),[table2keycolumn])). However, the loading process is taking forever , and I’m getting a timeout message. my list contains approximately 400,000 rows, while Table2 has around 6 million rows that I want to reduce to my list, Can you help me troubleshoot this issue or point me in the right directionSolved439Views0likes1CommentRe: how to reduce load size of multiple tables based on table 1 to Table 2 and then table 2 to many
sql and I think flooding is disabled .. not sure how to solve this when i do merge / filter / remove data it takes few min per table but when using SelectRows/List.Contains it takes forever. all I really want is to reduce data size based on Table1 keys to many tables .. not sure what I’m doing wrong772Views0likes0Commentshow to reduce load size of multiple tables based on table 1 to Table 2 and then table 2 to many
So I manage to filter Table2 by merging Table 1 content and applying filtering value based filter now i need to apply table 2 filter to additional 10 tables when applying same steps, based on Table 2 Im keep getting connection errors saying that duplicated values are not permitted and iam trying to avoid many to many relations. all i really need is efficient way to filter content of table 2 based on table 1 and then filter rest on Table 2Solved891Views2likes6Comments- 562Views2likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.