Column not appearing in query editor?

[markmess77]

I'm having this strange problem that I've never seen before. I am pulling data from a SQL table, but the last column is missing in the Power Query editor. I am therefore unable to perform any transformations on that column, which is causing some problems.

The strange part is that the column is visible in the Data tab when the query editor is closed. 

Is there anything that could be causing this column to be hidden in Power Query but visible in the Data tab?

[v-henryk-mstf · Accepted solution]

Hi @markmess77 ,

The reason for this is because all the columns displayed in the powerbi query come from the original data source. If the measure or column created by dax on the powerbi desktop can only be displayed in the data visual, it will not appear in the powerbi query. This is not caused by hidden.

If the problem is still not resolved, please provide detailed information, and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Cordial greeting dear, I am using if to generate a calculation but I only see 2 columns of the many I have, how can I solve this problem so that I get all the columns I have from the dimension FACTS?
Thanks a lot.

[v-henryk-mstf · Accepted solution]

Hi @markmess77 ,

The reason for this is because all the columns displayed in the powerbi query come from the original data source. If the measure or column created by dax on the powerbi desktop can only be displayed in the data visual, it will not appear in the powerbi query. This is not caused by hidden.

If the problem is still not resolved, please provide detailed information, and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[markmess77]

Sorry for the late reply, but the column that I am referring to is in my original data source. The column can be found within the SQL table that it is being pulled from, but it cannot be found within the Power BI query editor. However, the field is found in the report view once the editor is closed. No idea what is going on here.

[markmess77 · Accepted solution]

Ok figured it out. Only after hitting the Refresh Preview button at the source step in the query editor, the missing column appeared. Still weird that it was hidden in the query editor, but still available in the report view to begin with, but the issue has been solved.

[HCMARTIN]

This is exactly what happened to me.  Thank you very much for the solution!!

[Thejeswar]

Hi @v-henryk-mstf ,

If my understanding is right, any column or measure created in Power BI Desktop view for visuals won't be displayed in the Power Query editor.

Also just FYI, I don't see a hide option at all against the column name

Clarify if I am missing something here

[v-henryk-mstf]

Hi @Thejeswar ,

Yes, your understanding is correct. 😁

Might as well download the latest version of PowerBI Desktop from the official, which can display the same function buttons as mine.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@markmess77 

To answer such a question one would have to be able to re-produce the issue... unless you find someone that has already experienced this.