Forum Discussion

KasperJ90's avatar
KasperJ90
Helper III
3 years ago

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

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 fi...
Need Help
collinq's avatar
collinq
Super User
3 years ago

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's avatar
KasperJ90
Helper III
3 years ago

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's avatar
    collinq
    Super User
    3 years ago

    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....