Not able to connect Google Search Console

[Anonymous]

Hi,
I am trying to call Google Search Console API which required following format:

GET https://www.googleapis.com/webmasters/v3/sites/siteUrl/urlCrawlErrorsCounts/query

Where siteUrl is an encoded URL of the format:

https%3A%2F%2Fwww.example.com

 
However when I put that in to the Web.Contents function it always unencodes the Colon slashes meaning I can never reach the Google endpoint.


Please help me with this.

Thanks,
Swapnil

[adelheni]

 You can use one of the web connectors available, I've been using this article.
Hope this was helpful

[v-frfei-msft]

Hi @Anonymous ,

There is no built-in connector for Google Search console in Power BI Desktop, an idea about this issue has been submitted in this link, please vote it up.

In addition, you can contact Google Support about how to use Google Search Console API to retrieve data, then use "Get Data->Web" entry in Power BI Desktop or directly add connection information in Advanced Editor to connect to your API. There are some samples for your reference.

API Strategies with Power BI
Get Data from Twitter API with Power Query

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.