Add New Column to existing data in MS Lists

[Jayguy9]

Hello

I want to add a new column to the existing data set in my MS Lists and refresh my dashboard.

I have already built a dashboard based on the data set and at the moment the only way around it I can see is to create it again from scratch. However, there must be a way around it!

Help to avoid this would be GREATLY appreciated. 

[Arul]

@Jayguy9 ,

Do you want to add a new column in Power BI dataset?

[Jayguy9]

Hi Arul,

I added a new column in the MS List.  It is not coming over in the Power BI data set as I loaded it prior to adding the new column.  How do I add the new column to the dataset in PBI?

[Arul]

@Jayguy9 ,

Is it based on some condition that you need to add a column?

[Jayguy9]

Hi Yeah.  I need to add the column as additional data for the report.  I cannot figure out how to do so in Power Query

[Arul]

@Jayguy9 ,

Please share the sample dataset and expected output.

[Jayguy9]

Columns from the first snip are what I want, from a Microsoft List.  "Country" was recently added.
Second snip is from Data in Power Query