Forum Discussion
Going to a specific row in query editor
This is kind of a workaround, but what you can do is the following ..
Go to your Query editor, select the table you want the row from -> Select the row and add an index column from 1.
Then you can just search the specific row in the new coloumn you created
I believe this works if your dataset has less than 1000 rows.
If your dataset has more than 1000 rows, follow the instruction to add an index column, but then exit the query editor and create a table, add the column that will identify the row you want to see, and then add the Index column to the table.
Then, in Visual level filters, click on the Index field, choose the "is" operator and type in the row number you would like to see. This should show you the row you need.
Hope this helps!
You can also click a number in the index column. I used row 999 then click on your formula bar and replace 999 with the row that you want to go to.
= Table.SelectRows(#"Added Index", each ([Index] = 16859))