Refresh query to add new columns

[Caesarus7]

Hi all,

I'm looking to track the Coronavirus and update daily so I can see how many new cases there are. 

I am pulling the information from github.  

As you can see, each day new information is added to a new column.

My query is capturing new rows for new cases in different regions, but not the new columns for each new day's data. 

Can someone assist to advise how I can update the query to capture the new columns? 

Regards

Joel 

[#2]

@Sergei Baklan Thank you Sir for responding.

Actually when i add a new column in my Excel Table and then refresh in Power Bi it appears but with null values and it removes my other Column (Account Manager's Remarks) in Power Bi. and i now i deleted the last step changed type the error is not showing now but i lost my last column.

[#3]

@Muhammad_Faheem 

But "Account Manager's Remarks" column appears from your source on the Promoted Headers step. Looks like above name simply doesn't exist in you source table.

[#4]

Hi Sir,
Good Morning!
It did exist but when i inserted another column it disappear in Power BI.

[#5]

@Muhammad_Faheem 

Check step by step which column names you use in which of them.