Forum Discussion

Datahungry's avatar
Datahungry
Frequent Visitor
7 years ago

Refreshing report using Mixed Mode (Import Mode, Direct Query and Dual Mode) and Aggregations

Hello all,   I created a report that has these Tables: - "Sales" (all Sales detail by Date) - using Direct Query Mode, - "Sales Agg" (Same as "Sales" but aggregated by Year and Month) - using Imp...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Datahungry,

 

You can disable the query-option to try again. But warning: This is a global setting, so it will applied to other queries as well.

 

 

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-frfei-msft 

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?

Thanks,

Cem

 

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.

Cluster URI:WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID:2f87361a-6400-4634-90e1-c22e58578ca6
Request ID:f8a68b1d-0032-6001-6b4c-878e93b2c9f4
Time:2019-12-05 17:15:56Z