Changing source data from CSV to XML

[gill_133]

Hi all,

Will preface this by admitting I know very little about XML files or APIs. I have an existing PBI model that is built from CSV files. I'd like to change the input from CSV to XML files. I am not able to attach files, so I apologise for that. I've included some screenshots below, hopefully that helps. 

My test XML file contains similar data to one CSV file already in the model. I imported the XML file, transformed it to appear the same as the CSV file in Power Query, and then tried to copy/paste the rest of the applied steps from CSV file advanced editor (from the yellow highlighted section onwards) into the XML file advanced editor (after my initial transformation steps), but I just got a syntax error... 

Is what I'm doing fundamentally wrong, or is there more likely just a small error I've made?

CSV advanced editorXML advanced editor

Any hints or tips would be very much appreciated, I couldn't find anything on changing input to XML file specifically. 

Many thanks,

Gill

[gill_133]

That was it! Thanks Joyce. 

I had a few other syntax errors to address but they were fairly simple to find and address. 

Thanks again,

Gill

[isjoycewang · Accepted solution]

Unsure if it's the root cause, just to remind that remember to change the #"step name" to prior one.

If not, maybe you could let us know more about the syntax error detail. Thanks.

For example, if you need to paste on

#"Filter Rows" = Table.SelectRows(#"Renamed Columns2", each ......  from CSV editor

after

#"Renamed Columns7" = Table RenamedColumns(......  in the XML editor

please modify it as:

#"Filter Rows" = Table.SelectRows(#"Renamed Columns7", each ...... 

Best Regards,

Joyce