Forum Discussion
There's Not Enough Memory To Complete This Operation
Kumar11109, try to do step by step. one refresh per click. i know that's not the best practices but if you continuing with same problem it can help you provisory.
individual refreshing works fine, but who will do that every month with 50 data sources = 50 clicks :-) ?
Maybe your better to consoldate the data into a single data source first using SSIS.
or if that doesn't work try using SSAS tabular, this should then allow using SSIS to build each data set. You can then point your powerbi at this.
If you've not got any servers that you can use to run ssis/ssas on then another option would be to extract the data to files. SSIS or R could do this for you running from a pc. Then mash the files together in powerbi.
Thank You all, for the all the replies that you gave. I am pretty sure that it will be helpful if I encounter another such problem. I am now shifting to a better p.c. hopefully, that would help.
What worked for me was that I cleaned my memory and created a view on SQL to download only the required data.
