How to join two tables from different sources

I am attempting to filter a table from an Oracle database (about 2 million rows) to only show the values that include an ID from my filter table, ID_TABLE ( about 4000 rows of unique ID codes). The ID in the Oracle table is the primary key.


Most things I have tried (putting the ID_TABLE in a csv, joining the two tables, putting them in a named range and filtering) always cause the final output to completely refresh the entire 2 million rows of the oracle table upon completion. I am trying to avoid this as it takes 20+ minutes.


I even tried creating a function that joined the two tables 200 at a time to preserve query folding and it did not work any faster either.


What I landed on was converting the ID_TABLE to a text string and inserting it into the Oracle query directly. This worked when I had an ID list of less than 1000 IDs but Oracle does not accept strings longer than 1000 so it is not viable for larger sets of IDs.


Uploading the ID list to Oracle is also not an option as I do not have write access to the database.






If anyone has had any experience joining tables from different sources in power query or has any idea on what might work in this situation please let me know. I feel as if I have almost tried everything.


I am fairly new to Power Query as well and welcome all help of any kind. Any advice would be greatly appreciate.


Thanks!!!

Is this relevant?

https://blog.crossjoin.co.uk/2018/0...-power-bi-and-excel-power-query-gettransform/

Thanks for you response.
I have tried that but unfortunately it refreshes the entire background Oracle table of 2 million+ rows when loaded into excel.
If you know of any way to stop that refresh or any other join tips or tricks please let me know. I appreciate any help with this.