Forum Discussion
Helper Iadd column to existing data model
I encountered the same problem and finally found out how to add a new column in the existing data model:
Click 'Edit Queries' > Manage > Add items
then select the fields you want to add and click OK.
- MattRasmussen
In 2022, the navigation to do this has changed. I had this issue as well - we added new columns to the source table and required them to be added in our Power BI data model. Searching the help files only talked about adding custom columns, then I found this thread. Here's the navigation that I used:
1) Click on the Model tab.
2) Click the Transform Data button in the ribbon - the Power Query Editor will open.
3) Click the Choose Columns button in the ribbon - the Choose Columns dialog will open.
4) By default, all columns are already selected. You can click the OK button or deselect the columns you may not want in your Power BI data model as you see fit.
5) Click the Close & Apply button in the ribbon to close the Power Query Editor.
6) Save your work.
