Many-Many

[superpower]

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

[amitchandak]

@superpower , if you have SQL source , create a new connection and in that write a SQL to select distinct values.

Or try in DAX

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...