Dataflow error "The Query contains columns with complex types that cannot be loaded"

[KasperJ90]

Hi,

I am receing this error in dataflow:

I want to combine CSV Files from a folder and it works via Power BI desktop, but I am trying to create a dataflow to archieve some of the CSV files to minimize the load on the dataset. Why am I getting this error? If I open the CSV files individually dataflow regonizes the data type for each column correctly. 

[collinq]

Hey @KasperJ90 ,

If you look in the dataflow in the list of fields you can see which field is set to "Any" and/or which field(s) have "Report" in them or "List" in them or something other than data.  These are the fields within the dataflow that need to be adjusted.  The Service algortihms are more sensitive than Desktop so this is just a matter of finding the field(s) with the issue and resolving them in the dataflow.

[KasperJ90]

Hey @collinq 

Thanks for your reply. I have 218 CSV files (see the first 2 below). 
I do not see any reason this should not work? The "Content" meaning each CSV file is the only datetype with "Any".  Do you have a suggestion on how to fix this?

[collinq]

Hey @KasperJ90 ,

In that screenshot you actually have two fields - Content and Attributes - that are problems.  Since you aren't using them, just remove them and all is well.

I am assuming (hoping?) that you are appending all your CSV's and not having to do that 128 times....