Primary Key column indexing

[Vallirajap]

Hii all,

In PBI Desktop, I have a primary key column whose column size is large, so I need to add an indexing column to refer to the primary key.
Is there any option for that?

Anybody who knows, give me the solution.
Thanks in advance.

[Ritaf1983 · Accepted solution]

Hi @Vallirajap 

You can add an index column from PQ.
Please refer to the linked documentation :

https://learn.microsoft.com/en-us/power-query/add-index-column

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.