BI File exceeded the maximum allowed size of '1000000'

[geekmachine811]

The error is brought about when I try to place both the fields "Benefit" and "PaymentAmount" on the same table side by side as shown below:

The Table "vwEFTPaymentsInfo2" that contains the field "PaymentAmount" is filtered and the row count is 59,388.

dbo_vwEFTPaymentsInfo2 = dbtMedicalV4{[Schema="dbo",Item="vwEFTPaymentsInfo2"]}[Data],
    #"Filtered Rows" = Table.SelectRows(dbo_vwEFTPaymentsInfo2, each [Scheme] = 6518 or [Scheme] = 6907 or [Scheme] = 7321)
in
    #"Filtered Rows"

I don't understand how the query surpassess the 1000000 in this case

[lbendlin]

what are the links between these tables?  Bidirectional links are roughly equivalent to a cartesian product  (ie multiplying one table with the other).  That can get ugly fast.

[lbendlin]

Are these fields coming from different tables?  If yes, how are the tables linked? Single or both directions?

[geekmachine811]

Yes, the fields are from different tables. Its not an exactly direct relationship between the two tables but rather through several tables. 4 to be specific