Forum Discussion

markmess77's avatar
markmess77
Icon for Resolver I rankResolver I
5 years ago
Solved

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 transfo...
Need Help
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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's avatar
    markmess77
    5 years ago

    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.

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
5 years ago

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's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

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.