Adding Columns in existing table

Hi  Anonymous ,

You can add a column of Sheet2 in your original Excel, the data in it is your column that is not loaded in, and a primary key column

For example:

Sheet1：

Sheet2: The Score column is not loaded into the column

Use the same ID column as the primary key column, load this Excel into power bi

Here are the steps you can follow：

1. Enter Power query through Transform data, select Home – Merge Queries – Merge Queries.

2. Select the [ID] column of Sheet1 and the [ID] column of Sheet2, and select Join Kind as Left Outer.

3. Select the column to load into.

4. Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

I made changes into the excel file and the problem is resolved.

But, its not possible to add cloumn containing different text for each row in power bi. I didn't find solution for this!