Rest API V2

Running into an issue with the api’s
V1 only seems to work on smaller baq’s
V2 seems to work in the API module but I keep getting a failure when dumping it to excel with O Data feed - error = Details: “Access to the resource is forbidden.”

I used an API key but that didn’t help - what am I missing

thanks