Parameters Failed to Load on BIP Using List of Value

Atif Nisar

Content

Please help , Parameters are not loading whenever the rows exceeds more than 200 in List of values.

Luke Sharma

Hi Atif, just a little further information - please could you upload a screenshot of the Parameters selection as well?

Atif Nisar

Please see the attached screen shots

FPonte

Hi Atif.

I'm assuming the SQL Query works fine when running in SQL Developer or other SQL tool right?

Are you able to click on "View Data" and then "View Engine Log" and upload to the thread so we can investigate a little better. Please, if you want to remove any sensitive information from the log (server name, etc...), do so.

Cheers.

Fernando

Atif Nisar

Dear Fernando , 

Yes the Query for "List of Value" works fine when we execute it separately.  Actually I noticed that it works fine if i limit the number of rows in "List of value" to be 200.

If more than 200 rows then parameters doesn't load appropriately. 

 

Atif Nisar

Dear Fernando , 

Yes the Query for "List of Value" works fine when we execute it separately.  Actually I noticed that it works fine if i limit the number of rows in "List of value" to be 200.

If more than 200 rows then parameters doesn't load appropriately.