Forum Discussion

tonyororke's avatar
tonyororke
Icon for Helper II rankHelper II
6 years ago
Solved

XML Groups and Sub Groups

I ham using XML documents as data sources in Power BI. Each documents consists of groups and sub groups. I am trying to create a report using a matrix/table to display the data as below  I'm having ...
  • lbendlin's avatar
    6 years ago

    XML documents are hierarchical.  Tables are flat.  Rethink what you are actually trying to achieve, and then change your Power Query code accordingly. (Look at the Fill Down  function, for example)