I have a query (Table_Budget), containing +/- 2000 rows with a ID in a column. I want to link this column to another query (Table_Jobs) which contains the same ID. But, in this other query, there are more than 400.000 rows and in Power Pivor I receive an error that I do not have enough memory.
Is it possible to query Table_Jobs where only the rows remain with the same ID as in Table_Budget?
Hi Filip,
Is that a Power Query error or a Power Pivot error? You mentioned that Power Pivot raised the error, but I guess it's just a typo.
If it's power query you meant, you can try to filter the Jobs table:
-step 1: build the ID list from Budget table:
Then, add a new column in Jobs query, with this formula:
This column will contain -1 values for ID's not found in Budget, so you should filter these out to reduce the size of the Jobs table in Power Pivot.
Hello,
I receive "error" in all record of this new column
Can we see a sample file?
