I have a query, let's call it query A that runs on server A. I use the results from query A to pull data using query B on server B. The two servers dont' communicate (server A is Microsoft SQL Server, server B is Oracle). I followed the steps outlined in this post: https://community.fabric.microsoft.com/t5/Desktop/Using-results-of-one-query-to-feed-another-query/t... and it worked perfectly in testing a small number of results from query A. However, when I expand to over 1000 results from query A I receive error ORA-01795 on query B because the number of results from query A is more than oracle allows in the WHERE clause.
In theory I need to split my results from query A into groups of 1000 and update the WHERE clause in query B to say "where results in (1,2,3,...,1000) or results in (1001,1002,1003,...,2000)" etc. Of course this needs to be dynamic since the number of results will grow over time. The problem is I'm not sure how to do that in Power BI. Is it possible?
TIA
Rich
