Parse a nested XML file once in Power Query

[Jovan_2000]

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

[ams1]

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?