Parameters Failed to Load on BIP Using List of Value

Question

Content

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

Atif Nisar · Answer

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 · Answer

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.

FPonte · Answer

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