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

[Anonymous]

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. ?

[v-lili6-msft]

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