Is there any solution out there that is as easy to use as power query but handles 2gb of data?
For the kind of scenario you are describing I would like to recommend you Big Query, this is a fully managed service focused on work and process with big loads of data and has different use cases for example, analytics data warehouse and machine learning.
Since Big Query costs depends of the amoun of data procesed, this is a very good option with a price of $0.020 per GB being the first 10 Gb free, just keep in mind that the costs may are different depending from the zone you are working.
Finally Big Query can read the data from different sources, for the use case described by you sounds that load data from Cloud Storage will be a good opcion for you use case.