Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 ...
General Comment
Tips and Tricks
mpalha04's avatar
mpalha04
Helper III
7 years ago

Anonymous have you been successful in connecting the review data yet?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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?

    • mpalha04's avatar
      mpalha04
      Helper III
      7 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        What connectors have you tried? I believe the Oauth connector should work and then a function can be written in M to extract all of the reviews. I've seen Curbal write a function for a google data set here:

        https://www.youtube.com/watch?v=87UsaOYD-ZM