Call Bigquery REST API using Service Account

[Haripriya]

Hi,

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.

Big query connector with Service Account Authentic... - Power Platform Community (microsoft.com)

Thanks,

Haripriya