Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a SQL Server database table with about 2.5 million rows. A common task is for us to filter on a string column which has fewer than 1000 distinct values. In Power Query I can filter to items in this column, but they don't all show up, even when using the search field. Note that this is the case even after I refresh the preview and select "Load More" on the "List may be incomplete" warning.
I can use the text filter menu to filter to the missing values and they do show up then. They are just missing when using the Search field. These text values that don't show up were added to the database later than the values that do show up. I suppose in an unordered query they may be returned after the first million rows.
The reason I suspect this is a bug is because I can reliably get these values to appear in the filter list if I first select "Remove Empty" from the filter menu. If I do any ordering before the filtering they also show up. There are no empty values in this column - the database column has a "not null" constraint and I have manually verified that there are no nulls and no empty string.
Info:
Excel 2013 (15.0.4945.1000) MSO (15.0.4945.1001) 32-bit
Power Query Version: 2.46.4732.721 32-bit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.