Google Reviews and Trustpilot

[mpalha04]

Hello,

I want to know if there's any way to get data from TrustPilot and Google Reviews for my business without uploading csv files.

Any help would be appreciated.

Thanks!

[v-yuezhe-msft]

@mpalha04,

Do Google Reviews and Trsutpilot provide OData service or rest API? In Power BI Desktop, it is possible to connect to rest api using web connector and we are able to connect to OData service  using OData Feed connector.

Regards,

Lydia

[mpalha04]

Hi,

Accessing Google Reviews is done through Google My Business API. I have enabled it and created credentials (client ID and secret). Just not sure what next steps are to get the review data to PBI.

[v-yuezhe-msft · Accepted solution]

@mpalha04,

You can take a look at the following example.

https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/

Regards,
Lydia