Share via

Getting error while creating Azure Linked service to Big Query

Anand S 20 Reputation points
2023-10-21T00:21:59.7433333+00:00

Getting error while creating Azure Linked service to Big Query.

I am using user authentication, to connect to Bigquery.

Azure linked service failing to test connection.

I have given all the required info.

Project ID.

Client ID

Client secret

Refresh token etc

Please adivse

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions
Accepted answer
  1. ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
    2023-10-22T06:11:40.05+00:00

    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.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.