Forum Discussion

lojith's avatar
lojith
Frequent Visitor
1 year ago
Solved

How to add a new column to Excel table created by using from Power BI dataset

Hi,

 

I have connected excel to Power BI dataset and created a table using a few columns from the dataset. If I have to add a new column, how can I do that without having to redo the whole process of creating a new table from scratch. Dont see any option in excel. Thanks.

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, lojith 

    Thanks for the replies from SaiTejaTalasila and collinq. You can refer to their suggestion. Or you can try the following method.

    The inserted colomn named Column1, you can click the Queries & Connections and double left-click the connection.



    Then turn to the Definition page to modify the command text.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

     

     

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, lojith 

    Thanks for the replies from SaiTejaTalasila and collinq. You can refer to their suggestion. Or you can try the following method.

    The inserted colomn named Column1, you can click the Queries & Connections and double left-click the connection.



    Then turn to the Definition page to modify the command text.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

     

     

     

    • lojith's avatar
      lojith
      Frequent Visitor
      1 year ago

      Thanks Anonymous ,SaiTejaTalasila and collinq. That worked even though not a straight forward way. Feel there should be an easy way for layman users also to add a additional columns.

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    1 year ago

    Hey lojith ,

     

    If you launch the Power Query Editor in Excel it will work very similarly to the one in Power BI and you can add columns and such in there.