Hi Anand S,
Thank you for posting query in Microsoft Q&A Platform.
Usually, above error will happen when we used incorrect token, or your client id does not have proper roles and permissions in Google Big Query. Kindly make sure roles and permissions on Google Big query end for your client id. Consider checking below links also for same. Obtaining OAuth 2.0 access tokens and this community blog
Hope this helps. Please let me know if any further queries.
Please consider hitting Accept Answer
button. Accepted answers help community as well.