My problem is that if I try to refresh the Dataset (either by using the Refresh Now or the Scheduler) I get this error:
The query result is too large. Consider removing unused columns, adding visual filters, or reducing the number of string type columns.
Regarding "size" I checked and found out that:
-The PBIX file is ony 35MB.
-The SQL "SalesAgg" table size is 510MB. (u
-The SQL "Sales" table size is 6,9GB (but since this is in Direct Query Mode, it doesn't get loaded so I wouldn't expect this to be the reason, as I believe that's one of the main purposes of the Aggregations feature)
I'm experiencing the same problem when I trigger a refresh in the PBI service (either scheduled or manual). Disabling the query-option didn't help either. It works fine when I manually refresh the model in PBI desktop in my local.
Actually I can't even see which table in my model causing the trouble. Maybe you are able to see it with the below log?
Last refresh failed: Thu Dec 05 2019 18:15:56 GMT+0100 (Central European Standard Time) The query result is too large. Consider removing unused columns, adding visual filters, or reducing the number of string type columns.