Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Why Does My New Column Not Show in Power Query Editor?

Hi: I created and added a column to a table within the Data Model "section" of Power BI. Why in the world is this new column not showing within that same table in the Power Query Editor?   When I ...
Need Help
tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

Hi Anonymous ,

 

Your conclusion is correct, a calculated column added in the "front end" part via DAX will not pop up in Power Query. In fact, some changes in DAX do affect Power Query, i.e. renaming columns or deleting tables. 

 

So if you'd like your new column to appear in Power Query, you have to create it in Power Query:

 

 

Note, Power Query uses another language called M with a very different syntax than DAX.

 

Here some links where this exact matter was discussed:

Columns are not visible in power query | Power BI Exchange (pbiusergroup.com)

Solved: Why won't new column added to table show up on Pow... - Microsoft Power BI Community

Solved: Is there a way to make calculated columns show in ... - Microsoft Power BI Community

Column added in data tab not shown in query editor - Microsoft Power BI Community

 

Hope this helps! 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

caltamirano's avatar
caltamirano
Regular Visitor
3 years ago

When you load a table, Power Bi creates a query in the Power Query Editor.

 

After loading a table you have two options to add a new column:

  1. Go back to the Power Query Editor ((M language)
    If you use this option, the new column will be visible both in te Power Query Editor (step previous to load) and in the Data view (after load)
  2. Go to Data view (DAX language)
    if you use this option, your'e working in a table already loaded to the Model, so the new column only will be visible in Data view not in the Power Query Editor

    It's just timing. In both cases you can use the new column. It just depends when you do it.

    Hope it helps.
    Carlos