Getting a newly added column in SharePoint List to a Merged Query in Power Query

[DevadathanK]

Hi Community!

<Message deleted>

Thanks for any help!

[DevadathanK · Accepted solution]

I checked the source and saw that the newly added column is present in the preview of one of the 2 merge sourse datasets.

I then checked the next step, in which i had expanded the 2nd dataset (as it was a Left Outer Join).

In there i saw that the new column was not marked for visibility. When i checked its box, the column became available.

<Message deleted>

[amitchandak]

@DevadathanK , You can again repeat the merge step. Or right-click on the table in data transformation mode and open Advance Editor. Take a back that script and add columns there.

[nandukrishnavs]

@DevadathanK 

Create a duplicate of your existing pbix and follow the below steps.

1. Go to edit query
2. Navigate to the previous step of merge query
3. Add merge step again (You will get a popup - insert new step)
4. Now delete the old merge step

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂