Row index numbers changes

[tabuzahra]

Hello,

I'm not that experienced in Power Bi. Though, I have created an index for each row for the table (x) which starts from 1 and this table is read from an Excel sheet.

I also have excluded (filtered) some of those indexes as some rows have duplicates so I wanted to eliminate specific rows depend on the index number.

After I have applied it, i noticed that whenever the Excel sheet is modified and I refresh the table from Power Bi, those indexes numbers that were filtered has been changed.

Is there any solution that I can have fixed index number that will never change? or is there any solution to solve this issue?

[Nathaniel_C · Accepted solution]

Hi @tabuzahra ,

When you create an index in Power Query, it increments on every row. The only thing that I could see would be to hard code 1,2,3 into a column in Excel that is part of your table.  That way the values should read 1,3 if you delete row 2 and you retain your original numbering of the remaining rows.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel