Announcements
I need to send the data generated from powerapps to Bigquery. The backend for my powerapp is sharepoint lists. Is there a way to push the data to Bigquery on a button click event? Or export the data from sharepoint list to BigQuery. Appreciate any help
Hey @haripriya_adus,
There doesn't appear to be any built in Power Platform connector for BigQuery. You will need either use a Power Automate Flow to perform this job, a Custom Connector, or a combination of both.
I can see there is some API documentation for BigQuery. I am in no way familiar with BQ and suggest thoroughly researching your options for sending data to that service, then you could do something like:
There doesn't appear to be an existing connector for Bigquery. Bigquery does have a REST API, so you could build a custom connector to communicate with it. That's a premium feature, so you'll need a per app or per user licence to go with it.Hope that helps,
Bryan
Thank you BCLS776,
I tried querying BigQuery using the following link, I am ablet to get a 200 success message. But when I create a custom connector from powerapps using the same custom connector the authentication fails with the following error
@haripriya_adus wrote: Thank you BCLS776, I tried querying BigQuery using the following link, I am ablet to get a 200 success message. But when I create a custom connector from powerapps using the same custom connector the authentication fails with the following error Authorization Error Error 400: invalid_request Missing required parameter: scope Kindly help
Hi, I'm not able to support with specifics about BigQuery as I am not familiar with its API. However, the error message you are receiving indicates it is expecting additional information in your HTTP request. Have you tried using Postman to build a working collection with all of your desired API calls, and then using that proven collection to build the custom connector?
I did use Postman collection and I am able to query the BQ api for a sample get request, but using the same postman collection I created a custom connector, which throws the above error
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 360 Super User 2026 Season 2
M Bilal Khan 325
Mohsin Ali 232
