Forum Discussion
There's Not Enough Memory To Complete This Operation
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.