'%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)
Fix Power Query Data Profiling Options Missing in Excel
Question details
The user is unable to find data profiling tools in the Power Query Editor's View menu.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to analyze dataset quality and distribution using the Data Preview tools within the Power Query Editor.
- Observed behavior
- Advanced data profiling options are missing from the Data Preview menu, leaving only basic visual options like Monospaced and Show whitespace.
Ensure your computer has an active internet connection to download the latest Office updates, and save your current workbook before restarting Microsoft Excel.
Update Microsoft Office to a Supported Version
Data-profiling tools were introduced to Excel around 2022. Updating your Office application to the newest build is the standard fix to access these features.
If you are using a Microsoft 365 subscription, your software receives regular feature updates. Missing data profiling tools usually indicate that the application has missed recent updates or is stuck on an older release channel.
Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' (or 'Office Account') at the bottom left of the sidebar.
Locate the 'Product Information' section on the right side. Click the 'Update Options' button next to Office Updates.
Select 'Update Now' from the drop-down menu. Allow Microsoft Office to download and install any pending updates.
Once the update is complete, restart Excel. Open your data in the Power Query Editor, go to the 'View' tab, and check the 'Data Preview' group for the newly added Column quality, Column distribution, and Column profile checkboxes.
Try WPS Office for Your Spreadsheet Needs
If your current Office version lacks advanced data features or you are looking for a highly capable, cost-effective replacement, WPS Office is an excellent lightweight alternative to Microsoft 365.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx workbooks directly—no conversion required.
- 3. Analyze Your Data: Navigate to the Data tab to access built-in tools for filtering, sorting, and analyzing your datasets.
Frequently Asked Questions
Why do I only see 'Monospaced' and 'Show whitespace' in the Power Query Editor?
This happens when your Microsoft Office version predates the addition of data profiling features. Until the software is updated to a 2022 or newer build, only those basic text-formatting options will appear in the Data Preview group.
Are Power Query data profiling tools available in Excel 2016 or 2019?
No, standalone versions of Microsoft Office 2016 and 2019 do not include these specific data profiling features in Power Query. You will need Microsoft 365 or a newer release like Office 2021.
How do I check my current Microsoft Excel version and build number?
Open Excel, click on 'File', then click on 'Account'. Your exact version, build number, and update channel will be prominently displayed in the 'About Excel' section on the right side of the screen.
How do I turn on Data Profiling once my software is updated?
Open the Power Query Editor and navigate to the 'View' tab on the ribbon. In the 'Data Preview' group, check the boxes for 'Column quality', 'Column distribution', and 'Column profile' to display these insights above your data columns.
