Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Integrate Google Search Console API into Power BI

I'm using the Google Search Console API to retrieve the information and insert it into Power BI. I already have OAuth 2.0 client ID credentials with application type "WEB" In Power BI I selected th...
General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you for the help. Really the link you suggested managed to unlock the problem. Here's my code, hoping it might help someone else.

 

let
// Basic auth
authKey = "Bearer xxxxxx",
url = "https://www.googleapis.com/webmasters/v3/sites/mywebsite.com/searchAnalytics/query?startDate=2022-11-01&endDate=2022-11-03",
// bearer token
GetJson = Json.Document(Web.Contents(url, [Headers=[Authorization=authKey, #"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content=Text.ToBinary("grant_type=client_credentials")])),
#"Convertido em Tabela" = Record.ToTable(GetJson)
in
#"Convertido em Tabela"

 

Thanks!

moizsherwani's avatar
moizsherwani
Continued Contributor
2 years ago

Hi Anonymous , I am trying to do the same but haven't been succsessful, two questions

 

1) is the bearer auth key the onhe to get from API centre called developer token

2) what type of "access web content" is to be selected (Annonymous, Basic, Web API, etc)

 

Thanks,

 

Moiz