Forum Discussion
Changing previous steps in "edit queries"
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.
Anonymous
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.
5 Replies
Hi Anonymous
I think it would help a lot if you shared the pbix with the query at issue
Anonymous
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.