Forum Discussion
Google My Business Reviews API
Has anyone been able to list all of their reviews in My Business via Power Query?
I am trying to list all reviews from multiple locations and already have an established key. I get an error when I test the URL for a single location in a web browser:
{
"error": {
"code": 401,
"message": "Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",
"status": "UNAUTHENTICATED"
}
} I have tried connecting through Power Query but I get the error:
"A Web API key can only be specified when a web API key name is provided." I am trying to connect to the source through the web connector and pass the key through the WEB API access.
I've followed the steps outlined by Google but still cannot figure this one out:
9 Replies
Anonymous,
Based on the article, you need to use OAuth credential to access the Google My business API. I would recommend you get OAuth credential first, then use Power Query to connect to the API following the guide in the blog below.
https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/
Regards,
LydiaAnonymous have you been successful in connecting the review data yet?
We are still waiting to hear back from google regarding our API key. They have not responded to the request that went in over a month ago. I would like to use Power BI to pull google reviews in for all of our locations but I feel like our hands are tied by google and they are not responsive. Has anyone else had success using Power BI to pull google reviews?
I would like to do the same with Power BI and Google Reviews.
I got my API credentials and key. I even tried playing around with the API with the OAuth Playground, and it seems to work... I'm just stuck on connecting to Power BI.
