'%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 BI Not Detecting a New Excel Column
Question details
The user needs to make a newly added Excel column visible and accessible within Power BI Desktop after updating the source data.
- Product
- Excel / Power BI Desktop
- Device & OS
- not provided
- Scenario
- Adding a new column of data to a source Excel file and attempting to load or sync it into an existing Power BI project.
- Observed behavior
- The newly added Excel column does not appear in the Power BI Desktop data model or fields pane after clicking refresh.
Ensure that the source Excel file containing the new column is saved and fully closed, as Power BI cannot read structure changes from a file that is currently locked by another application.
Expand the Excel Table or Source Range to Include the New Column
Use this solution if your source data in Excel relies on a specifically defined range or an Excel Table that hasn't automatically expanded to include the new column.
Power BI pulls data based on explicit ranges, Named Ranges, or Excel Tables. If you add a column adjacent to an existing dataset but outside the defined Table boundary, Power BI will ignore it entirely during a refresh.
Open the Excel workbook that acts as the data source for your Power BI project.
If your data is formatted as a Table, look at the bottom-right corner of your dataset. You should see a small sizing handle. If this handle does not encompass your newly added column, the column is not part of the Table.
Click and drag the sizing handle to the right to include the new column. Alternatively, select the entire dataset including the new column and press 'Ctrl + T' to re-apply the Table format.
Save and close the Excel file. Return to Power BI Desktop and click the 'Refresh' button on the Home ribbon to pull in the updated table structure.
Update Power Query Settings to Detect the New Schema
Use this method if the column is definitely inside the Excel source range, but Power BI is still filtering it out due to hardcoded steps in Power Query.
Edit and Prepare Excel Data Seamlessly with WPS Office
While Microsoft Power BI handles complex data visualization, maintaining a clean, well-formatted source dataset is crucial. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office, making it incredibly easy to structure your Excel files before importing them into Power BI.
- 1. Download and Install: Download WPS Office Free from the official website and install it on your device.
- 2. Open Source Data: Open your .xlsx or .csv data source file using WPS Spreadsheet.
- 3. Format as Table: Highlight your dataset and press 'Ctrl + T' or navigate to the 'Insert' tab and click 'Table'. This ensures dynamic range expansion for seamless Power BI integration.
Frequently Asked Questions
Why does Power BI skip newly added columns in Excel?
Power BI skips new columns if the source data is not formatted as a dynamic Excel Table, if the new column falls outside the defined Named Range, or if the Power Query 'Changed Type' step has hardcoded the original column list.
Does formatting my data as an Excel Table help Power BI detect new columns?
Yes. Formatting your raw data as a Table ensures the data range boundaries expand automatically. When you add a new column to a Table and save the file, Power BI detects the updated boundaries automatically during the next refresh.
How do I force Power BI to refresh the data model schema?
Open the Power Query Editor by clicking 'Transform Data'. From the Home tab, click the drop-down under 'Refresh Preview' and select 'Refresh All'. This forces Power BI to re-read the entire schema from the underlying Excel file.
What if the new column is still missing after refreshing Power Query?
Review the 'Applied Steps' pane in the Power Query Editor. Steps like 'Removed Other Columns' or 'Removed Columns' may be explicitly filtering out your new data. Remove or adjust these steps to allow the new column to pass through to the data model.
