Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • MattAllington's avatar
    MattAllington
    Community 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?