Forum Discussion
Converting XML data to a table
Hello all, I am trying to reach out to our organisation's HR data and shape the data on PowerBI Desktop. We are connecting through API and the data structure is XML. When I connect to the...
Anonymous,
You can pivot Attribute::ID column, select Element::Text column as your Values Column, and under Advanced Options, choose Don't Aggregate.
Anonymous,
You can pivot Attribute::ID column, select Element::Text column as your Values Column, and under Advanced Options, choose Don't Aggregate.
Anonymous Thank you! This is what I've been looking for!