Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |