Forum Discussion
Solved
64-bit Excel Power Pivot stuck on "reading data" for a small one-to-many relationship
Hi, Can anyone please tell me why the Excel Power Pivot for this simple one-to-many data model never finishes "Reading data..."? Masters has 6000 rows Sub Accounts has 63,000 rows The sa...
I see, thank you for the feedback. PivotTable, if no aggregation (other words nothing in Values) returns Full Join of two tables which are in relationship. In your case that's 63,000 x 6,000 = 378 million of values.
That takes time, especially taking into account that, most probably, for major part of the data is used memory cache on hard drive.
I see, thank you for the feedback. PivotTable, if no aggregation (other words nothing in Values) returns Full Join of two tables which are in relationship. In your case that's 63,000 x 6,000 = 378 million of values.
That takes time, especially taking into account that, most probably, for major part of the data is used memory cache on hard drive.
Hi SergeiBaklan thanks for your explanation which has now made me understand the underlying issue.
I guess the Power BI Desktop team have put in additional code to avoid this FULL join.
I guess the Power BI Desktop team have put in additional code to avoid this FULL join.