Forum Discussion

nayanpatel's avatar
nayanpatel
New Member
1 year ago
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...
Data Protection
Need Help
Tips and Tricks
  • nayanpatel's avatar
    nayanpatel
    1 year ago

    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.

lbendlin's avatar
lbendlin
Super User
1 year ago

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's avatar
    nayanpatel
    New Member
    1 year ago

    Hi,

    Its import data in power Bi using Import query method.

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

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

      • nayanpatel's avatar
        nayanpatel
        New Member
        1 year ago

        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.