Forum Discussion
Solved
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...
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.
Hi,
Its import data in power Bi using Import query method.
So you observe the row count increase without ever creating a visual?
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.
I agree with you.
