Power BI Custom Connector Combo Box Only Showing First 1000 Values

[Suraj_Ncircle]

Hello,

I am currently developing a custom connector for Power BI and have encountered an issue with the combo box drop-down functionality. The problem is that the combo box is only displaying the first 1000 values, even though the data source contains more than 1000 entries.

Questions:

1. Is there a known limitation in Power BI or the Power Query M language that restricts the combo box to only show the first 1000 values?
2. Are there any workarounds or best practices to overcome this limitation and display all values or enable dynamic loading of additional values?
3. Could this be an issue related to my implementation in the custom connector? If so, what specific areas should I review or modify?
   

   I would greatly appreciate any guidance, suggestions, or examples from the community to help resolve this issue.

   Thank you in advance for your assistance!
   
   

   

[Anonymous · Accepted solution]

Hi @Suraj_Ncircle ,

Yes, Power BI has a default limitation where certain controls, like combo boxes, column profiling , may only display a maximum of 1000 items. This is likely a performance-related constraint to ensure that the user interface remains responsive. You can get more details in the following links.

Why does my query run multiple times - Power Query | Microsoft Learn

Using the data profiling tools - Power Query | Microsoft Learn

Solved: How to increase the number of rows in preview at P... - Microsoft Fabric Community

You can search and type the values which want to search and after 1000 options, and check if you can find the values. If yes, it indicated that the required data be loaded. However, you won't be able to see more options because of the 1000 option limit for PQ mentioned earlier.

In addition, please check your permission of data sources with limited rows and if you add some filters in the data source.

Best Regards