Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
hamishpolson
Regular Visitor

Import error - column not found.

Hi there,

 

I have imported an excel file that I have had to manipulate as it has double headers. To achieve this I had to pivot the rows into columns temporarily and then unpivot it back to its original format. This source file is to be updated weekly with a new data file in the same format. One of the columns is 'product' and this can have different values that appear and drop off as relevent in the period that data is pulled for.

 

The problem I have is that when I update the source file and attempt to refresh, I get an error that a column is not available. The column it highlights is not a column from the original source file but a column from when the data has ben pivoted that includes a now removed product from the source file.

 

Can anyone please suggest how I can address this so the dashoard can be refreshable?

 

Thank you in advance.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Before pivoting the data, use the demote headers function from the GUI.  Now when you pivot, your first column becomes Column1, Column2, etc. Now, when you unpivot again, the original tabke

column names won't matter; they'll all be "Column1", "Column2", etc. 

--Nate

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Before pivoting the data, use the demote headers function from the GUI.  Now when you pivot, your first column becomes Column1, Column2, etc. Now, when you unpivot again, the original tabke

column names won't matter; they'll all be "Column1", "Column2", etc. 

--Nate

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.