Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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.
Solved! Go to Solution.
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
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |