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.
9,753 questions
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 38,201 Reputation points Microsoft Employee
    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