How do you show a complete table after applying some steps in power query?

[DavidBuchi]

Hello Power BI community! Please I need your help.

So I have a table and on this particular table, I applied a filter on the table based on a certain column value. I did all these steps in powerquery. The value I am referring to in this case is actually a blank cell and so i wanted to see what exactly is blank in this table so that is why i used the filter.

I used the filter and it turns out that I had a whole row in my table that is blank. I remove that row via powerquery. 

Now this is where my problem lies, I am trying to go back to my data table after steps of filtering and removing that blank row has been done but i do not know how to.

I hope my question is clear.

[MFelix]

Hi @DavidBuchi ,

In Power Query each step you do is a transformation that you apply to your data in this case to what I can see you just applied the filter step to understand what was the data on the blank values correct?

Just delete the filter step from your Power Query steps and everything should be fine, taking into account that you are referring that you removed the blank row.

[DavidBuchi]

Thank you for your response. I have tried what you said and i am still seeing the blank row even when i go to the data table unfiltered.

[MFelix]

Hi @DavidBuchi ,

when you refer to the data table unfiltered what do you mean? Each step does a change, for each step is a "different" table so you will always get the result with the specific step applied. What is important is the last step of your query that is the combination of all your steps.

[DavidBuchi]

By data table unfiltered I mean the original table that has not have any filtering going on. Yes the last step of my query is the combination of all my steps but when I use the filter I just see one row out of a large number of rows and this is okay because i am using the filter to get anywhere that is blank. But the issue now is that, i cannot go back to my original table that has all the table rows without all the filtering and removing of the blank columns undoing.