DataSource.Error: Oracle: ORA-01795: maximum number of expressions in a list is 1000

[oluong]

Hello everyone,

Using the example from this page:  https://radacad.com/dynamic-sql-using-power-query#comments

I have a table call private_charges_facts where a column respondent_seq (unique identifier) which I turned into a list called Respondent_list (no duplicates).  I want to create a new query called respondent_DIM that will pass respondent_list into my new query to get only the records that I need from private_charges_facts.  All syntax went well until I refresh and hit the oracle limit (see below).  It's fine if my respondent_list is below 1000 records.  Any other way to approach this?

DataSource.Error: Oracle: ORA-01795: maximum number of expressions in a list is 1000
Details:
DataSourceKind=Oracle
DataSourcePath=prod
Message=ORA-01795: maximum number of expressions in a list is 1000
ErrorCode=-2147467259

[Anonymous]

@oluong, 

You could try to split the list into several smaller lists that has fewer than 1000 members, then use OR conditions in your WHERE statements for each list.