DataSource.Error: exceeded 100000 distinct ids Details: [List]

[Anonymous]

I have a query against a SalesForce object, and the list of records is currently filtered down to 3. I am then merging that object with another object using a field with a common value. When I then try to expand the columns from the merged table, I'm getting the below error. Being fairly amature in coding in Power Query etc, I've tried to google the issue and can't find anything.

The strangest thing is that this was previously working without hitting an error. I changed 1 field in a different table, and then this query started to show an error. I tried reversing the change I made in the other table but it didn't return this query to a happy state.

"DataSource.Error: exceeded 100000 distinct ids
Details:
[List]"

[amitchandak]

@Anonymous , refer, these two old solution

https://community.powerbi.com/t5/Power-Query/DataSource-Error-exceeded-100000-distinct-who-what-s/m-p/445281

https://community.powerbi.com/t5/Power-Query/DataSource-Error-exceeded-100000-distinct-who-what-s/m-p/591882