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