Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Clarification on PowerBi Table and Excel File located in Sharepoint

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)

NoDepartment CodeDepartment/SectionDesignation
1Administration1GeneralGeneral Manager
2Administration2GeneralAssistant  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)

NoDepartment CodeDepartment/SectionDesignationTotal PlanFuture PlanDifference
1Administration1GeneralGeneral Manager770
2Administration2GeneralAssistant  Manager000

 

 

General Comment
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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