Data Import & Export

Fix Excel Adding Unexpected Columns When Refreshing Power BI Data

Maira Mehtab Oct 12, 2026 870 views

Question details

The user needs to prevent an invisible or unexpected extra column from appearing in an Excel worksheet after refreshing a connected Power BI dataset.

Fix Excel Adding Unexpected Columns When Refreshing Power BI Data

Product: Microsoft Excel / Power BI
Device & OS: not provided
Scenario: Refreshing a data connection linked to a Power BI dataset or external source within an Excel workbook.
Observed behavior: An extra column that does not exist in the original Power BI source file automatically appears in the Excel worksheet upon data refresh.

Before you start

Create a sanitized backup copy of your Excel workbook so you can safely test query adjustments and data connections without risking data loss.

Solution 1Recommended

Inspect and Modify Power Query Steps

Use the Power Query Editor to identify and remove any transformation steps that are automatically generating the extra column.

Often, an unexpected column is the result of a lingering query step, such as an accidental 'Expand Column' or 'Add Custom Column' action recorded in the query history. Removing this step resolves the issue.

Launch Power Query Editor

Open your Excel workbook, navigate to the 'Data' tab on the ribbon, and select 'Get Data' followed by 'Launch Power Query Editor'.

Review Applied Steps

In the Query Settings pane on the right side, carefully click through each action listed under 'Applied Steps' to observe where the unexpected column first appears.

Remove or Edit the Problematic Step

Once identified, click the 'X' icon next to the step to delete it, or click the gear icon to modify the columns being expanded or extracted.

Close and Load

Click 'Close & Load' in the Home tab to save your query modifications and refresh the Excel worksheet with the correct structure.

Query Structure Updated: Once the steps are corrected, future data refreshes will strictly follow the updated column schema.

Solution 2

Adjust the Excel Table Range Properties

Verify that the destination table in Excel is not incorrectly sized or configured to insert new columns automatically.

Solution 3

Create a Sanitized File for Community Troubleshooting

Prepare a secure, anonymized version of your file to share with support teams if the issue persists.

Free Microsoft Office alternative

Try WPS Office for Seamless Data Handling

While resolving complex Power BI integration requires troubleshooting Microsoft's specific ecosystem, WPS Office serves as a highly compatible, free alternative for all your everyday spreadsheet needs, data analysis, and formatting.

1. Download the Software: Visit the official WPS Office website to download the free, lightweight installation package.
2. Install and Open: Run the installer. Once complete, open WPS Spreadsheets.
3. Work with Excel Files: Open your existing .xlsx workbooks directly in WPS Office to enjoy seamless formatting and fast data processing.

Free and lightweight Microsoft Office alternativeExcellent compatibility with Microsoft Excel formats (.xlsx, .xls, .csv)Powerful built-in data analysis and PivotTable featuresFamiliar tabbed interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Query automatically add an 'Index' or 'Custom' column?

This occurs if a query step was previously created to generate an Index or Custom column and was never deleted. You can resolve this by checking the 'Applied Steps' in the Power Query Editor and deleting any unwanted column creation steps.

Can a change in the original Power BI dataset cause new columns in Excel?

Yes. If the underlying Power BI dataset, dashboard, or connected SQL view has a new column added to its schema, refreshing the connected Excel file will pull in this new data structure unless you explicitly limit the columns within the Power Query Editor.

How do I stop Excel tables from expanding automatically and including adjacent columns?

To prevent Excel from automatically expanding table ranges, go to File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type, and uncheck the option for 'Include new rows and columns in table'.

What is the best way to share an Excel file for troubleshooting without exposing sensitive data?

Create a duplicate of the file, manually replace real names and financial data with dummy text (like 'Company A' or '123'), remove any hidden sheets, and upload the file to a secure cloud service to share a restricted view-only link.

Excel & Data Problems