topic Re: Power BI row count increases when loading two tables in Developer

Power BI row count increases when loading two tables

nayanpatel — Thu, 06 Feb 2025 13:52:41 GMT

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

Re: Power BI row count increases when loading two tables

lbendlin — Fri, 07 Feb 2025 00:43:38 GMT

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).

Re: Power BI row count increases when loading two tables

nayanpatel — Fri, 07 Feb 2025 05:18:33 GMT

Hi,

Its import data in power Bi using Import query method.

Re: Power BI row count increases when loading two tables

lbendlin — Fri, 07 Feb 2025 21:17:42 GMT

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

Re: Power BI row count increases when loading two tables

nayanpatel — Mon, 10 Feb 2025 05:20:16 GMT

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.

Re: Power BI row count increases when loading two tables

NancyThomasson — Tue, 11 Feb 2025 11:56:58 GMT

I agree with you.