Forum Discussion

Jovan_2000's avatar
Jovan_2000
Regular Visitor
3 years ago

Parse a nested XML file once in Power Query

I am struggling with the following problem: I have an XML file that contains several nests. There are several nested XML files. The goal is: To read in all XML files in Power BI, i.e. Power Query, and parse them once. Do you have a solution, how to do that? .I guess I need to apply normalization to avoid the duplication and create new columns to do it. But unfortunately I don't know how to do that. Can you help me ?

123

Need Help

1 Reply

  • ams1's avatar
    ams1
    Responsive Resident
    3 years ago

    Hi,

     

    A sample file is worth 1000 screenshots ğŸ˜Š - can you please provide a sample xml to see its structure (1 x item will be enough)?

    If you provide a sample file, don't forget to remove confidential information from it.

     

    Besides the sample: You're saying that you'd like to import multiple XML files all with the structure described above?