Dataflow failed to refresh

[Andrew_na_lang]

Hi Power Bi Family,

My PBI dataflow failed to refresh for some reason even though no changes were made. 

I got this error message and am not sure if it has something to do with the file size of my table. 

Error: DataSource.Error: ODBC: ERROR [HY000] [Microsoft][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState HY000] out of memory for query result; Request ID: 1c18f2c2-ced9-c89f-6bf2-6327e82c665c Activity ID: 5c2a4d11-8a6f-4407-b5ef-b879017e83b1

What should I do to fix this issue without deleting the tables I have in my dataflow? Any assistance is much appreciated!

More power! 

[v-xiaotang · Accepted solution]

Hi @Andrew_na_lang 

Thanks for reaching out to us.

>> My PBI dataflow failed to refresh for some reason even though no changes were made. 

If there is no change, it may be related to this issue, please see Support | Microsoft Power BI

Best Regards,

Community Support Team _Tang

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

[amitchandak]

@Andrew_na_lang , seem like one of the steps in dataflow taking too much memory. Check the recently added steps and try to simplify it

There is video from Guyinacube on memory usage https://www.youtube.com/watch?v=lopTsclrpHI