Jon von der Heyden
MrExcel MVP, Moderator
- Joined
- Apr 6, 2004
- Messages
- 10,912
- Office Version
- 365
- Platform
- Windows
Hi
I have a query in Power query, which loads to a Table in a worksheet.
The query is a very simple:
There are no subsequent steps whatsover.
The query retruns 3 date columns and 11 decimal columns.
I have done some diagnostics and profiling, and even eyeballing the data, the result set contains no errors. Three of the decimal columns have nulls, otherwise there are no further nulls.
It is returning 231 results.
I get this error when trying to load the results to the Table in the worksheet: [DataFormat.Error] We cannot return the data produced by this query because of its complexity.
I have found a fix. I have removed errors across all columns (new step). This avoids the error at load. However it still returns 231 results. I think this is odd because this, along with profiling, suggests that there are no errors.
Has anyone encountered this, and can you explain this behaviour?
Many thanks.
I have a query in Power query, which loads to a Table in a worksheet.
The query is a very simple:
Code:
select * from db.view where order_number = '4100278642' order by order_date
There are no subsequent steps whatsover.
The query retruns 3 date columns and 11 decimal columns.
I have done some diagnostics and profiling, and even eyeballing the data, the result set contains no errors. Three of the decimal columns have nulls, otherwise there are no further nulls.
It is returning 231 results.
I get this error when trying to load the results to the Table in the worksheet: [DataFormat.Error] We cannot return the data produced by this query because of its complexity.
I have found a fix. I have removed errors across all columns (new step). This avoids the error at load. However it still returns 231 results. I think this is odd because this, along with profiling, suggests that there are no errors.
Has anyone encountered this, and can you explain this behaviour?
Many thanks.