Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Add an extra field from a data source

A power bi newbie here.  Say if I import a table A from a data source into power bi, some minor changes to the imported dataset. calculated columns, measures etc. Now I add a new field in the table...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago
    Anonymous

    If I didn't misunderstood you, when you refresh in power bi desktop your new added column will automatically be imported.
ankitpatira's avatar
ankitpatira
Community Champion
10 years ago
Anonymous

If I didn't misunderstood you, when you refresh in power bi desktop your new added column will automatically be imported.
  • mathysbt's avatar
    mathysbt
    Regular Visitor
    10 years ago

    Hi,

     

    I expected the functionality to work as you explained, but it doesn't for me.

     

    I am using a local file. It is an Excel spreadsheet with a table. The table has 4 columns. If I add a fifth column with data, I would expect the field to show up in Power BI after a refresh. I click refresh for the datasource and it refreshes successfully. Then, I go to report and the new field does not show up. The only way to get the new field is to delete the old datasource and add a new one.

     

    Thoughts?

    • carinat's avatar
      carinat
      Advocate II
      10 years ago

      I have the same problem: If I add a column to my original data source in Excel and refresh in Power BI, my new column doesn't show up. Is it possible to get the new column or is the only way to start from scratch? (I'd rather not since I've build relationships to other sources, added calculated columns, etc.)