'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Power Query Filter Values Disappearing After Load More in Excel
Question details
Users need to resolve an issue where filter options vanish in the Power Query Editor after attempting to load more distinct values.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Filtering data retrieved from SQL Server, CSV files, Excel workbooks, or table/range data sources within the Power Query Editor.
- Observed behavior
- Filter values completely disappear from the drop-down list immediately after the user selects the 'Load More' option.
Verify the exact version and build number of your Excel application (e.g., Version 2203), and check if the filtering issue is isolated to a specific data source or occurs across all your database connections.
Update Microsoft 365 to the Latest Build
Installing the latest Office updates often resolves known bugs with Power Query UI elements like disappearing filters.
This issue is frequently tied to specific Microsoft 365 builds (such as Version 2203, Build 16.0.15028.20218). Updating to a newer build replaces the buggy Power Query engine components with patched versions.
Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom of the left-hand menu.
Under the Product Information section, click on 'Update Options' and select 'Update Now' from the drop-down menu.
Wait for the updates to download and install. Once complete, restart Excel, open your Power Query Editor, and test the 'Load More' filter function again.
Recreate the Query with a New Data Source
If updating does not work, the existing query or workbook connection file may be corrupted and needs to be rebuilt.
Try WPS Office for Stable and Efficient Data Management
If you are experiencing persistent bugs with Microsoft Excel's data tools, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative with powerful spreadsheet capabilities.
Frequently Asked Questions
Why do filter values disappear when I click Load More in Power Query?
This is often caused by a known software bug in specific Microsoft 365 builds (such as Version 2203) where the Power Query Editor's user interface fails to properly render the extended list of distinct values from larger data sources.
Does this issue affect all data sources?
While it doesn't affect every single source, it has been widely reported to impact SQL Server databases, CSV files, existing Excel workbooks, and local table or range data sources.
How can I check my current Excel version and build?
Open Excel, click on 'File', then select 'Account' from the bottom left menu. Your version, build number, and bitness (e.g., 64-bit) will be displayed clearly under the 'About Excel' section.
What should I do if updating Excel does not fix the Power Query filter?
If updating does not resolve the issue, try creating a completely new workbook and establishing a fresh connection to your data source. If it still fails, you may need to report the issue to support, providing your exact build details.
