Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

adding new column to excel data source

hi all
my original excel data source has column A,B,C and it working fine in dashboard.

when i added a new column "D" to the excel data source and refresh doesnt update it.

did i missed out anything?

Thank you.

Need Help

7 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    6 years ago

    Anonymous 

     

    Does the new column appear in the query editor when refreshed?

    The best way to handle Excel data sources IMHO is to create tables within excel (selecting the whole range and use ctrl + t to create the table and giving it a name). You then use this table itself as the source in Power BI. If you add columns or rows to the table, you will be sure Power BI picks them up efficiently.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      PaulDBrown no...the column didnt appear when refresh in edit queries...

      Rows did get refreshed.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      This has literally saved me so much time and frusteration. Thank you!

       

      "The best way to handle Excel data sources IMHO is to create tables within excel (selecting the whole range and use ctrl + t to create the table and giving it a name). You then use this table itself as the source in Power BI. If you add columns or rows to the table, you will be sure Power BI picks them up efficiently."

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        I'm assuming this won't work if you already had a report built out with the xcel file in regular spreadsheet form then want to add columns and change it to a "table" format, right?

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Please refer this

    https://community.powerbi.com/t5/Desktop/Power-Bi-does-not-detect-newly-added-columns-to-connected-csv/td-p/65033

    https://community.powerbi.com/t5/Desktop/Add-a-new-column-to-the-existing-data-set-and-refresh/td-p/116592

     

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks.

    My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

  • Seban's avatar
    Seban
    New Member
    2 years ago

    I was facing the same problem. The issue was i had removed all the other columns except the selected column in Power Query. Check whether you have removed other columns in applied steps. If you have that jus remove that and you can see all the columns in source file.