How to add additional column from existing data set

[biflake]

Hi,

I could not find a a way to add additional columns from an exisitng data set. It looks like I have to create a new query to accomodate that.

I thought it should be readily available to bring additional columns from an existing data set.

Thanks.

[EvenMyrvold]

Hi,

I must agree with biflake that this should be a very fundamental feature, i.e.:

It should be possible to choose an existing source where possible columns in a table is selected and where the alredady selected columns are marked - and where you can then select the additional columns that you need in your dataset.

[v-yuezhe-msft]

@biflake,

What is your data source? Do you add new columns into your data source and want to bring new columns into Power BI Desktop?  If so, you can click Refresh in Power BI Desktop to bring new columns.

Also you can go to Advanced Editor of the current query in Power BI Desktop, and check if you can add the columns in the source code.

Regards,
Lydia

[biflake]

I'm using SAP BW as the data source. I'm just trying to add additional column from the same data source. The refresh does not provide you a way to bring the additonal columns. If I select and load another column from the existing data source then it creates a new query and loads that column.

I did not find a way to add that within advanced editor..

This is not making sense to me as this should be a very fundamental feature.

[v-yuezhe-msft]

@biflake,

You can add new dimension column in Advanced Editor as shown in the following example. Otherwise, you would need to re-connect to the data source , then re-choose the columns and measures you need.



Regards,
Lydia