Connect Google PageSpeed Insights to Power BI?

[Anonymous]

Hi all

Is it possible to connect or get the data from Google PageSpeed Insights into Power BI?

Thanks

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Yes, it is possible. You could go to Get data > Web and enter the API url along with the url parameter in the URL textbox.

For example,

https://www.googleapis.com/pagespeedonline/v5/runPagespeed?url=https://developers.google.com

Replace https://developers.google.com with the web URL you want to test.

Wait a while for Power BI to get the data from this API, you will get its response data in JSON format. You can then transform the query to extract the info you want.

Here is the document for Google PageSpeed Insights API.

https://developers.google.com/speed/docs/insights/v5/reference/?apix=true

https://developers.google.com/speed/docs/insights/v5/get-started?hl=en

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak]

@Anonymous , Does it provide REST API, Then you can data using rest API.