Forum Discussion

gill_133's avatar
gill_133
Frequent Visitor
2 years ago
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...
Need Help
  • isjoycewang's avatar
    isjoycewang
    2 years ago

    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

isjoycewang's avatar
isjoycewang
Solution Supplier
2 years ago

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