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.
Pandreoni's avatar
Pandreoni
Frequent Visitor
8 years ago

Same issue. How do show the new column which I just created in the data source (Excel table, new column added but not shown in Power Bi desktop data field)? somehow I cant do those steps suggested above. thanks 

Benegade's avatar
Benegade
Regular Visitor
8 years ago

I had the same issue - with Excel tables I couldn't perform the steps mentioned here as they apply only to CSV files.

 

I found a workaround for Excel files/tables that seems to work for me, so thought I'd share it.

 

I found that I had to save a copy of the existing file e.g. save as Filename_1 or similar, then go data source settings, change data source and select the new file. The new columns then appear.

 

You could then go back and save as the original file name, and change data source back to that again to retain the existing file.

 

Hope that helps.

 

Ben