Forum Discussion
Connect identical tables without append
Hello Community,
I have Three tables:
1. 50M rows that i dont need to refresh.
2. 2M rows that i need update anytime
3. 0,5M rows that i need update monthly
Those three tables are identical, 28 columns, i cannot append because of slow performance when i need to update table 2 or 3.
I tryed:: table = Union(1,2,3), but i stopped at not sufficient memory problem
The problem is on slicer: I did this table to use as slicer, to get all the distinct values to this column from the three tables.
SLICER 01. COMPANY = FILTER(DISTINCT(UNION (VALUES('TABLE1'[COMPANY]);VALUES('TABLE2'[COMPANY]);VALUES('TABLE3'[COMPANY])));[COMPANY] <> BLANK())
So, i got 27 slicer like that. But the slicers dont filter other slicer and the PBI do not allow to crossfilter.
How can i connect those 3 identical(shape) tables without append and the slicer filtering themselves ?
Thanks!
1 Reply
- MattAllingtonCommunity Champion
Refreshing 58 million rows should not be an issue. It sounds to me like the 28 columns are the issue. What is the data, and why are there 28 columns?