I am betting the issue is the third one - the time limit. There is a 2 hour time limit on refreshes with a Pro license. I am wondering if you can maybe get the three files separately? Or, make your query more efficient somehow? Or, maybe make the source file smaller (ie. if it is a lot of years of data and you only need the last 5 then trim the source before you try to hit it).
But, I think that is the first place to look - to get the refresh time under 2 hours. Preferrably way under 2 hours so that if the data grows a bit you aren't in the same position quickly.
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut! Private message me for consulting or training needs.