Data.Format.Error Cannot load the data as it's too complicated

[Naiyez]

Hi,

I was getting the error when calling power query in Excel to extract data from SAP.

which is saying that the data I got from the query is too complicated to load back.

Originally when I build the query, it worked well on my laptop but the error occured when I try to send to spreadsheet along with the query to the user. I also did not find any similar errors or any solutions. Anyone here would be able to help? Thanks in advance for your time and suggestions!

Naiyez

[v-yalanwu-msft]

Hi, @Naiyez ;

You could try to remove errors across all columns (new step). This avoids the error at load. 

Please refer to this url.

[DataFormat.Error] We cannot return the data produced by this query because of its complexity. | MrE...

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.