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
Datahungry's avatar
Datahungry
Frequent Visitor
7 years ago

Hi Frank,

Thanks for the reply. I tried what you suggested but nothing changed. I still get the error message:

 

The query result is too large. Consider removing unused columns, adding visual filters, or reducing the number of string type columns.

 

Is this a bug? Anyone else experiencing the same problem?

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes, exactly the same problem

 

Something went wrong

The query result is too large. Consider removing unused columns,
adding visual filters, or reducing the number of string type columns.

 

What I did, removed all the unused columns, reduced the data size to almost  nothing and still the same problem.

When I click on refresh on the online Power BI, I get the yellow triangle with the above message.

Now the data volume is almost nothing, so somethings else is going on here.

 

Eric