Forum Discussion
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...
- Anonymous
If I didn't misunderstood you, when you refresh in power bi desktop your new added column will automatically be imported.
My data source was a SQL. Same solution. Go the Source Cog and REFRESH PREVIEW on the toolbar. The new columns will appear. Thank God because my build has over one hundred relationship tables.
To add to this. I had a SQL data source. Going into "Edit Queries" and refreshing made the column appear in the preview. However after clicking "Close & Apply" and viewing the fields in the dataset in the right hand panel, the new column still wasn't appearing. I'm not sure if this had something to do with the fact that I had already added some calculated fields.
My solution was to go back into "Edit Queries" and simply move the column from the end to another position in the table. This created a "Reordered Columns" step. After closing and applying now, the new field appeared in the right hand panel. Hope this helps someone.