Showing results for 
Search instead for 
Did you mean: 
New Member


Hi, colleagues,

I have a problem evidently with indexing:




The initial code in the Advanced query is:

 #"Added Index" = Table.AddIndexColumn(#"Renamed Columns6", "Index", 1, 1, Int64.Type),


How to fix it, I tried:

#"Added Index" = Table.Buffer (Table.AddIndexColumn(#"Renamed Columns6", "Index", 1, 1, Int64.Type)),


Then it refreshed and showed error in this line:

#"Duplicated Column" = Table.DuplicateColumn(Source, "DepositClass", "DepositClass - Copy"),


But it is correct.

May be you have an idea how to fix it?


Super User
Super User

Hi @MistyRose ,


Without the full code is difficult to give you what is happening in full however from the code you present I cannot determine that the error comes from the buffer since the Duplicated step is refering to the Source step and the Index step is referecing the Renamed Columns step.


I believe that if the error was related with this step the errors would come on steps that relate with the Index step or are after taht step being related with it.


Can you share full code? If it has sensitive information share it trough private message


Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!