Project {project-id} is not found and cannot be used for API calls
Go to the https://script.google.com/home/usersettings and enable 'Google Apps Script API'.
I have managed to resolve this now and I did so by clicking 'Resources->Advanced Google Services'. This had a link to the 'Google API Console', if you follow it the console will have the correct project selected and you can enable the Big Query API.
I couldn't find another way to get the correct project selected, although I'm sure there is one.