Forum Discussion

Shawry's avatar
Shawry
Helper I
2 years ago

Adding new column to data source

Hi,    I've built a dashboard, but need to add another column (in column AC) to the source file. I've tried adding the column to the end, however, when I refresh the PowerBI workbook, the column is...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Shawry ,

Regarding your question, does the new column exist in your original data source file? If not, please move it to the original data source file. Generally, after clicking the refresh button, the new column will appear automatically.

Shawry's avatar
Shawry
Helper I
2 years ago

Hi Anonymous 

Thanks for you reply. 

Yes, I have included the column in my original data source, and you can see it being loaded and included in the initial table. Please see below, where you'll notice the Forecast column in column 29.

However, you'll see that after the Removed Other Columns1 step - column 29 has been removed. 

I cannot seem to find a way to prevent this step of the query from keeping column 29 and not removing it. The M code for this line is:

    #"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File (10)"}),

Which doesn't seem to reference actual column names, so I'm wondering how it's actually being coded to determine which columns to keep? 

Thanks