0

Is there a way to call a Bigquery Rest API using service account? I need to push data from my powerapp to bigquery and I find the only way out is to create a custom connector. But due to org policies I am constrained to use a service account for authentication. I could not figure out a way to create a custom connector that authenticates through a service account. Following is my post on powerapps forum. Any help would be highly appreciated.

https://powerusers.microsoft.com/t5/Connector-Development/Big-query-connector-with-Service-Account-Authentication/m-p/1853380#M1739

Thanks,

Haripriya

Currently I am able to call BQ get api from a sample dataset with personal gmail credentials, but I get authentication error when I try with my org login. It is possibly because my org userId would not have permissions to query the API. I will have to use the service account that has the permissions. But I could not figure a way out to authenticate via a service account.

Hari Adusumalli
  • 1
  • you would need account with valid license/subscription. In your org case service account license could be trail as well for Testing but you definitely need account – AnkUser Nov 07 '22 at 09:24

0 Answers0