Unable to combince the csv (Binary) files in DataFlow

[Alirezam]

Hi

I don't have any issue combining multiple csv files in Power Bi query editor. However, when I try to do the same process in 'DataFlow' I receive a Mashup text error and the following message. Anyone knows what is the alternative way of combining the files without using 'Content [Binary]' which also ends up with some "transform files"?

Thanks

 

[Anonymous]

When I try to merge the binary format, I receive this problem.

[ChrisPowerUser]

Do somone solved this problem ?

[lbendlin]

There is a rather large difference between ingesting data from XML files and from csv files.  For CSV files you can use the built-in table column expansion, but for XML you need to write a separate parser function that can return a table.

I would recommend you practice on your PC with a couple of CSV files  (using the binary combine) to see which code Power Query autogenerates. Then, once you have understood it, you can move on to cut out all the extra code as I described above.  Only after that should you try and add the XML parsing.

If you would like help with that last part please provide a handful of sample XML files and indicate your desired output.

[lbendlin]

These don't look like CSV files.

Usually you use Table.AddColumn () and then manually expand them.  Best if you have a static list of columns available so you don't have to read the first file twice (like the standard Power Query combine process does).

[Alirezam]

Hi thanks, you are right that was a mistake, the files are .xml but does not make any difference still having the same issue. Where should I find " Table.AddColumn () " ? this does not appear in my query.