Hi All!
I am using power query to query an ODBC to oracle and return the results to excel... I have done it many times in the past. I am trying to ODBC - "advanced" sql so I can filter the data coming back from the server to make it as fast as possible. It hangs. Main query is being filtered by the subquery using a WHERE XXXXX IN(subquery)

So main query works with out limiting records and the subquery works by itself when testing... but together it just hangs.. just to note (not sure if it is the problem) the subquery and the main query both query the same table - I did give each one a different alias.... table BCS.TEBIT_REPORTING_TV

Please Login or Register  to view this content.
Thanks
Steve - Harrisburg