Adding a column post query

[dseppi]

HI!

I recently connected PowerBI desktop to Dynamics online. When I connected the table Opportunities I filtered a majority of the columns before saving the query. Everything worked great. Unfortunately, I missed a column. Does anyone know how to go back and grab that column without having to create a new data table and merging it with the original table? i.e. it would be great if I could go back to the Opportunity table and click the checkbox to simply add the column I left out.

Thanks for any insights!

DS

[dseppi · Accepted solution]

Disregard. I figured it out. I went to the nav bar on the right of the query where it lists the steps I had taken, clicked on Removed Columns step, which pulled up the filter I had placed. I was able to easily add it back in by checking the "createdon" column.