Changing source data from CSV to XML

Question

Hi all,&nbsp;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.&nbsp;&nbsp;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...&nbsp;Is what I'm doing fundamentally wrong, or is there more likely just a small error I've made?&nbsp;CSV advanced editorXML advanced editor&nbsp;Any hints or tips would be very much appreciated, I couldn't find anything on changing input to XML file specifically.&nbsp;&nbsp;Many thanks,Gill

isjoycewang · Accepted Answer

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

Forum Discussion

Changing source data from CSV to XML

2 Replies

Related content

Data source

Changing Data Source

Data Source Credentials Password Change

Data source Schema changed

Data Source Credentials