Moving data from Google Sheets to Excel via Power Query

[TheSeal]

I have a simple but large Google sheet I want to put into Excel and have the ability to refresh. The Google Sheet has 180 columns and currently 45 rows (records) it is populated via a Google Form so the number of records will grow. I installed Power Query, copied the URL of the Google Sheet and pasted it into "From Web" in Power Query. It worked well and appeared to refresh appropriately; however, it would only bring in the first 100 columns then tell me the download failed. How can I get it to read all 180 columns?
Pertinent versions
Excel 15.0.4535.1511
Power Query 2.33.4337.481 32-bit

Thanks!

 

[James02]

Divide the Google Sheet into two files (essentially two separate tables). Join the two tables in Excel via Power Query or Copy/Paste or create relationship.