Changing previous steps in "edit queries"

[KGuyton]

I created a dashboard using an API from a website.  They website changed the source of the data causing me in error in my retrieval.  The data used to be in 'Column 7' it has been moved to 'Column 8' as you can see from the  yellow labeled "list" hyperlink.  I need to change my step labeled "column 7" which expanded that column. to expand column 8 instead without losing all my steps afterwards.  Is this possible?  I do not recall all that went into those steps afterwards and it is causing my entire report to break.

[AlB]

Hi @KGuyton

I think it would help a lot if you shared the pbix with the query at issue

[KGuyton]

http://s000.tinyupload.com/index.php?file_id=08277110776792610340

[AlB · Accepted solution]

@KGuyton

In the 'Responses' query, at step 'Column 7' you have:

= #"Transposed Table"{1}[Column7]

If you change that for

= #"Transposed Table"{1}[Column8]

it seems to work. Try it and let me know.

You could also rename that step Column8 instead of Column7, to avoid confusion later.

[KGuyton]

Perfect! thank you.

[v-chuncz-msft]

@KGuyton, By the way, you may help accept solution. Your contribution is highly appreciated.