Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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.
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.