Building huge data table from 2 smaller one efficiently.

[Anonymous]

Hi All!

I have a bit of a challange on how to combine huge data efficiently and build a report on top of that.

I have 2 lists both not too big in their own List Shops and List Products. We have like 150 shops for now and 370 products that are the same in all shops. How can I put all those in one table or connecting them in a way that the report will recognise all shops with all products? It will be 150*370 row of data, but I dont know how to combine them in this way inside PowerBI.

For example:

Shop A Product 1

Shop A Product 2

...

Shop A Product 370

Shop B Product 1

...

Shop B Product370

... and so on...

[zenisekd · Accepted solution]

@Anonymous, 150*370 is not a big table...

I believe what you are trying to achieve is called "cartesian join". Here is a solution: 
https://radacad.com/cartesian-product-in-power-query-multiply-all-sets-of-all-pairs-in-power-bi

[Anonymous]

Lifesaver, thank you! I tought it should be easy to do just couldnt find it myself.