Forum Discussion
Power BI Custom Connector Combo Box Only Showing First 1000 Values
- Anonymous2 years ago
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
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