Copy of a large SQL table, with condensed column values

[Anonymous]

Hello smart people!

I have a large table which pulls complete data records for over 30 fields.  However, I need a duplicate table with the new table only showing records with one of the fields filtered to 1 of 2 values.  When I created the SQL call, PowerBI is saying it cant refresh as the call takes over 3600 seconds (!).  As the 2nd table is a filtered copy of the original table, how can I do this without having to do 2 different SQL calls?

Thanks in advance!

[vcastello · Accepted solution]

Hi @Anonymous

You could try ...

1.- Open the query editor
2.- Import the Big Table.

2.- Create a 'Reference' of the Big Table. (Right click the big table and select reference)

3.- In the reference ... Filter by the fields you need.

4.- Close the query editor

Vicente

[Anonymous]

ThankYou!!!

[vcastello]

You're welcome