[SQLState HY000] out of memory for query result

Hello Team,

I am facing the most common issue of refresh data, i have huge dataset i.e 2million records while trying to sync in power bi cloud this doesnt work, below is the exception i get. Can you please help us to resolve this issue or provide us an hint on how to proceed further.

Unfortunately there was a problem.
Error processing data in the dataset.
Please try again later or contact support. Provide the following details when contacting support.
Data source error: ODBC: ERROR [HY000] [Microsoft] [Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState HY000] out of memory for query result
. The exception was raised by the IDbCommand interface. Table: visiteddialognodes.
Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID: cd38b4b2-4fcf-477b-97b4-a4770ddff172
Request ID: 76621808-cb0c-9ca7-6b46-f3d5cbb0cd3b
Time: 2020-03-10 06: 14: 12Z

I tried syncing this using power bi desktop this working without any issues.