Forum Discussion
Dataflow failed to refresh
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!
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.
2 Replies
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
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.
