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

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Found the solution to my query result is too large error.

     

    What did not work :
    Reduced the data to almost nothing.
    Removed all the pages except one.
    Removed all the visualization except one.

     

    What did WORK :
    Removed a table (lucky first one I tried) and that worked.
    Without this table, I can press refresh on Power BI Online
    and it works.

     

    Without this table Power BI Online successfully refreshed.
    So, I confirmed this was the table giving me the error.

     

    But I need this table, so I removed all the measures etc
    so that I only have the native columns from the table.

     

    Still had problems, so I restarted and kept only the measures
    and columns that I need. Turns out in the columns that I
    did comment out was one of the columns that was causing the
    refresh error.

     

    Then I keep only the columns that I need and comment out
    all the rest. Well, that solved my problem.


    Sounds easy but this took a day and a half to figure this out.

    I can now press refresh on Power BI online with no errors 🙂

     

    Also, quick tip, when you get data, use the Advanced options
    section and the SQL statement (optional, requires database)
    box to enter your select.

     

    When you have 50 columns etc
    use only the columns you need and comment out the rest.

     

    select
    col1
    , col2
    --, col3
    --, col4
    , col5
    from table

     

    Hope this helps someone with this issue.

     

    Eric (Montreal, Canada)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Eric,

       

      I'm experiencing the same problem.

      The table you changed, was that a DirectQuery, Dual or Import table? So I can focus on a set of tables on my model, rather than trying each of them one by one.