Forum Discussion

biflake's avatar
biflake
Regular Visitor
8 years ago

How to add additional column from existing data set

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    biflake
    Regular Visitor
    8 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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