Clarification on PowerBi Table and Excel File located in Sharepoint

[Anonymous]

For eg. I have 4 columns in Employee Table and i saved it as Employee excel file and i link them into my sharepoint folder when using powerbi. (Table 1)

(Table 1)

No	Department Code	Department/Section	Designation
1	Administration1	General	General Manager
2	Administration2	General	Assistant  Manager

My question is if i add additional column into the Employee Excel file. For eg. (Table 2). How do i ensure that the Powerbi has added this column in for me? Will clicking the refresh button helps in PowerBI. 

Kindly advise. Thanks!

(Table 2)

No	Department Code	Department/Section	Designation	Total Plan	Future Plan	Difference
1	Administration1	General	General Manager	7	7	0
2	Administration2	General	Assistant  Manager	0	0	0

[amitchandak · Accepted solution]

@Anonymous , usually when you refresh it next time, it should get added. Otherwise add as a new table, copy-paste initial few line and carefully paste in old code

very similar to this

Abstract Thesis Part 51: Change Connection from One source type to another Source Type and use existing steps: https://youtu.be/nwYJgG2hmd0

[Anonymous]

Copy - paste initial few line and carefully paste in old code? 

Do you mean by copy the values from excel file and then paste them into powerbi as new column?

[v-shex-msft]

Hi @Anonymous,

Power query will cache the data structure into query steps if you add or remove files on your data source side. You need to check the query steps and manually modify the definitions. (it will be stored in 'change type' and other steps which reference the table structure)

Add or change data types (Power Query) (microsoft.com)

Regards,

Xiaoxin Sheng

[Anonymous]

Thank you.

Another question i have, is the column names in my excel and powerbi are different. I only want to edit the column names in powerbi instead of excel. This is because i have added DAX expressions in powerbi. How do i resolve this issue?