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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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