Many-Many

Hi!

In my report, there are multiple set of tables with many to many relationships. I have created bridge tables and able to solve the report. But the problem is, the data is very huge for these tables almost more than 300+ million rows. So, when I created the bridge table, the memory is doubled up and the file size has blown up to 6 GB. I tried to convert the tables to direct query but some of the transformations that I did for creating bridge tables are not supported in direct query. So, are there any options to create a bridge table virtually that doesn't oaccupy any additional memory.

Thanks