Various Errors when Refreshing Google Sheets Data

I've found this seems to work for me as I was getting the missing column error all the time (Maybe 1 in 10 refreshes would work. 

Warning: This is a bit of a faff so it won't be practical if there are lots of tabs in one document.

I take the google sheet URL:

https://docs.google.com/spreadsheets/d/randomseriesofcharacters/edit#gid=984654321

The gid=984654321 denotes the individual tab.

I change the URL to this

https://docs.google.com/spreadsheets/d/randomseriesofcharacters/export?format=csv&gid=984654321

This will load the individual tab into Power BI through the web connector - like I said not manageable to have so many data sources if you have data in lots of tabs but for individual tabs it's working fine for me.