Forum Discussion
Solved
Changing source data from CSV to XML
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...
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
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