Forum Discussion

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
6 months ago

Hi Arpit6075,

Have you had a chance to review the solution we shared by nathancwatkins? If the issue persists, feel free to reply so we can help further.

 

Thank you.

Arpit6075's avatar
Arpit6075
New Member
6 months ago

Hi v-saisrao-msft ,

Solution not helpled as replied answer given the Limitation not the suggested solution or answers

  • nathancwatkins's avatar
    nathancwatkins
    Helper II
    5 months ago

    The answer is "What kind of system have you built that allows a user to select 400-500 items?" Maybe you need to put these items into categories, and pass those as a list. Also, if you are not already, wrap your list in List.Buffer--it makes a HUGE difference. Your list is already being added to the SQL as a single string, as evidenced by it appearing as the values in the IN[] clause.

    Final thought, does your native query have to use that filter at all? In this case, it seems that you'd be better off not using that filter in the native SQL, and just use the slicer that you already built as an actual slicer for the data.


    Are you running a query containing 4-500 items each time a user makes a slicer selection?

     

    --Nate