Power BI row count increases when loading two tables

[nayanpatel]

Hi friends,

I have two tables, first table with say 40000 rows. second table with 9000 rows. When I load both table and there is no relationship created in Model view still my First table rows count increases by 390000. This may be happned due to cross join internally. But what is the solution for this. Please help

Thank you

[lbendlin]

Please clarify what you mean by "load".  As soon as you have a visual with columns from both tables you will get a cartesian (cross join).

[nayanpatel]

Hi,

Its import data in power Bi using Import query method.

[lbendlin]

So you observe the row count increase without ever creating a visual?

[nayanpatel · Accepted solution]

Hi,

Yes and as far as i know its common behaviour of Power BI. Because, internally its engine finds the common data from any columns and create cross join. when we specify expicitely relationship, the rows should be reduced to correct data. this is as per my knowledge only.

[NancyThomasson]

I agree with you.