Forum Discussion
Resolver IPull Records where ID#s are from another Query
rjs2 Best thing, create a view on the Oracle server that does an inner join between the tables. Or, use a Merge query to do the same in Power Query (might fold)
Greg_Deckler I think I will just pull the history table with the record table, then reference that to a new table to build the history table off that. And just clean up the record table to remove duplicates. It may even run faster that way.
I really wish there was a way you could do more in the WHERE clause.
Resolver II should have added that I cant make any views or stored procedures in our environment due to restrictions.
The table I am connecting to is a history table for the customer record that logs changes.
So you are saying there is no way for me in PBI to make a list from query1 of seq# and then use that list in the WHERE clause of query2 from the history table to only pull and load records associated with those seq#?
Resolver IGreg_Deckler I think I will just pull the history table with the record table, then reference that to a new table to build the history table off that. And just clean up the record table to remove duplicates. It may even run faster that way.
I really wish there was a way you could do more in the WHERE clause.