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

 

Need Help

3 Replies

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