cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
markmess77
Resolver I
Resolver I

Column not appearing in query editor?

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?

2 ACCEPTED SOLUTIONS
v-henryk-mstf
Community Support
Community Support

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.

v-henryk-mstf_0-1618800757737.png

v-henryk-mstf_1-1618800777172.png

 


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.

View solution in original post

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.

View solution in original post

6 REPLIES 6
v-henryk-mstf
Community Support
Community Support

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.

v-henryk-mstf_0-1618800757737.png

v-henryk-mstf_1-1618800777172.png

 


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.

View solution in original post

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.

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.

View solution in original post

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

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.

daxer
Solution Sage
Solution Sage

@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.

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors