Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Not able to connect Google Search Console

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

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

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

     

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi Anonymous ,

       

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

       

  • adelheni's avatar
    adelheni
    Helper III
    4 years ago

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