Connect identical tables without append

[Anonymous]

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!

[MattAllington]

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?