cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KarenCuellar08
New Member

Connect Google PageSpeed Insights to Power BI?

Hi all

 

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

 

Thanks

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @KarenCuellar08 

 

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.

051902.jpg

 

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.

051903.jpg

 

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.

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @KarenCuellar08 

 

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.

051902.jpg

 

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.

051903.jpg

 

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.

View solution in original post

amitchandak
Super User
Super User

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!