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

[jellis1971]

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 click to "Transform Data", my new column is not there.

That is one of the strangest things that I have ever encountered in my nearly three decades in IT.

When you add a column in one area of the application, does it not "transfer"?

If not, how do I get my new column to appear in Power Query Editor?

Thanks!

John

[tackytechtom · Accepted solution]

Hi @jellis1971 ,

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]

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