Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Direct Query Error: - Query result is too large in Power BI service.

Hi,

 

I have a report in direct query mode and in desktop it is working fine but in service, it is throwing below error for table visualization. Also i only have 339k records into table visualization and in backend query is running for 1 min 16 seconds
 

Could you please help me understand what needs to be done in this case. ?

Need Help
Tips and Tricks

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    If you could try to update the gateway and try it again?

    and if you could remove the unused columns and try it again?

     

    Best Regards,

    Lin