Hi All
I have a list of establishments that contain 350 000 rows. The list is stored on a power bi dataset.
in my case i want the possibility to select an establishment over the 350 000 rows.
I've created a combobox based on the establishment list and i've activated the search possibility on that combobox.
It work but it's very slow because he's trying to get over 350 000 rows.
i've activated the search option on the combobox properties.
Now i'm trying to filter the combobox with a TOP50 of establishment that match with the text that the user is writting on the combobox search box.
In the combobox properties, there's "On Select" and "On Change" properties but it's not the event i'm looking for.
I would like to execute a TOP 50 filter request during the search moment. For exemple, when the user is writting text on the search box of the combobox, i want to request the dataset with a top 50 of the establishment that match with the text.
Is it possible to do that ?
Many thanks for your help.
best regards