transform data in power query

Create Index column using a Power Query in Power Bi

Using a Power Query, you can add index column to your data that serves as a row counter to rows in data table, it is really a best feature of power query.