The resultset of a query to external data source has exceeded the maximum allowed size of '1000000'

[Anonymous]

Hi,

Select all on date filter(having 5 months of data)  shows data in table visual andwhile when I select 3 months  at that time table show error.

[v-chenwuz-msft]

Hi @Anonymous ,

This is a limitation. Maybe you can try to apply more filtering on this table to reduce rows.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.