Getting the values as a column header in semantic mode

Hi Ar_Sh 

This issue happens when the Power Query step order changes after adding new columns. Power BI ends up treating the data values as headers instead of column names.

Could you please try below steps:

1. Open Power Query Editor.

2. In the Applied Steps pane, find the step named “Promoted Headers” or “Use First Row as Headers.”

3. Move this step to the bottom, after all other steps (like adding or unpivoting columns).

4. If the step is missing, go to Home >> Use First Row as Headers and apply it again.

5. Click Close & Apply, then refresh your report.

1. Identify the step in Power Query where you perform the pivot or unpivot transformation.

2. Move the step where you add the new columns so it is included at the same point as the pivot/unpivot operation, do not add them before or after unrelated transformations.

3. Ensure the new columns are created in the correct shape, so Power Query does not misinterpret their values as column headers on refresh.

4. Refresh and verify that column values are not being used as headers, and headers are consistent.