cmcreynolds
Active Member
- Joined
- May 21, 2015
- Messages
- 295
Good morning - I know there was an Excel 2016 update earlier this week and I'm not experiencing an issue with my queries in PQ.
SIDE QUESTION: Is there now a 100 column limit?
I'm pulling in a field [CreatedDate] and it is timestamped with date and time, but I don't need the time. So, the only thing I've done in the past is converted the field from "Date/Time" to "Date" and bam, it is fixed. However, when I refreshed my reports this morning, I received this error:
DataSource.Error: Non-grouped query that uses overall aggregate functions cannot also use LIMIT
Details:
List
(I'm not grouping or aggregating anything, just a simple pull)
Now, usually, my reports are rather complex BUT the ones I'm working on now are so simple - I just pull in the data, remove irrelevant columns, reorder them, (try) to change the date, and filter one field before letting it export to a table. That's it! No calculations, nothing. I thought I might be "required" to add to the Data Model, so I even did that, and the error is still there.
Anyone know of a fix/work around?
SIDE QUESTION: Is there now a 100 column limit?
I'm pulling in a field [CreatedDate] and it is timestamped with date and time, but I don't need the time. So, the only thing I've done in the past is converted the field from "Date/Time" to "Date" and bam, it is fixed. However, when I refreshed my reports this morning, I received this error:
DataSource.Error: Non-grouped query that uses overall aggregate functions cannot also use LIMIT
Details:
List
(I'm not grouping or aggregating anything, just a simple pull)
Now, usually, my reports are rather complex BUT the ones I'm working on now are so simple - I just pull in the data, remove irrelevant columns, reorder them, (try) to change the date, and filter one field before letting it export to a table. That's it! No calculations, nothing. I thought I might be "required" to add to the Data Model, so I even did that, and the error is still there.
Anyone know of a fix/work around?
