Forum Discussion
How do you show a complete table after applying some steps in power query?
Super UserHi 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.
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.
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.