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.
KelvinMorel's avatar
KelvinMorel
Helper II
7 years ago

Hi,

 

I know this post is marked as Solved, I just want to add my experiance on this issue.

 

When you add a column to the data source file, on Power BI or Power Query into 'Query Editor' you should Refresh All but after that nothing will change because your column selection refers to the first source file you loaded and is being used as 'Sample File'.

A new 'Sample File' will be created under 'Transform File from Data' (on the left Queries [#] column).

 

To solve this issue just choose the right 'Sample File' in the 'Manage Parameters' menu