Forum Discussion
Google My Business Reviews API
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.
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
I haven't tried using any connectors other than Web and Odata feed. I never used an Oauth connector before, so I'm not too sure how to go about it? Do you have any reosurces that can explain how to go about that?
Unfortunately I do not. Sorry
Any luck connecting your API to Power BI? I'm not sure if the web connector is the best choice since a gateway refresh is not the best for web connectors.
Hi Anonymous,
Have you already managed to obtain the Google Reviews in Power BI?
