Going to a specific row in query editor

[CloudMonkey]

Hi,

Please can you tell me how to go to a specific row of a table in the query editor? (I'm trying to scroll but it is extremely slow and the table is very large)

Thanks,

CM

[v-huizhn-msft]

Hi @CloudMonkey,

You add a index column as @BeemsC posted. Then you can use the index number to identify each row of table.

Best Regards,
Angelia

[MarcelBeug]

It may also depend on why you want to scroll.

If you want to select a value, then you might better apply some filtering.

If you just want to scroll, it may be faster to scroll in the data view rather than in the Query Editor.

Or create a visual with a slicer.

It might be an option to split your query (right click the next step and choose "Extract previous"), so there will be a table at the step where you want to scroll and you can scroll in the data view.

[BeemsC · Accepted solution]

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

[Anonymous]

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!

[rpopecpa]

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))