Forum Discussion
Data.Format.Error Cannot load the data as it's too complicated
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
1 Reply
Hi, Naiyez ;
You could try to remove errors across all columns (new step). This avoids the error at load.
Please refer to this url.
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.
