Forum Discussion
Column not appearing in query editor?
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,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.
This is exactly what happened to me. Thank you very much for the solution!!
