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
markmess77's avatar
markmess77
Icon for Resolver I rankResolver I
5 years ago

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's avatar
markmess77
Icon for Resolver I rankResolver I
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.

  • HCMARTIN's avatar
    HCMARTIN
    Regular Visitor
    2 years ago

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