Forum Discussion
Power BI row count increases when loading two tables
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
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.
5 Replies
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).
Hi,
Its import data in power Bi using Import query method.
So you observe the row count increase without ever creating a visual?
