cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Razik_BNPL
Frequent Visitor

Retrieve data from google support device error

Hi, Im tryin to retrive data from this link. but there is an error, we were unable to retreve contents of the page

https://storage.googleapis.com/play_public/supported_devices.html

1 ACCEPTED SOLUTION
v-yiruan-msft
Community Support
Community Support

Hi @Razik_BNPL ,

Please use Web.Page instead of Web.BrowserContents, and paste the below codes in your Advanced Editor. Please find the details in the attachment.

let
  Source = Web.Page(Web.Contents("https://storage.googleapis.com/play_public/supported_devices.html")),
  Navigation = Source{0}[Data]
in
  Navigation

vyiruanmsft_0-1685413631304.png

In addition, you can refer the following link to try to resolve the problem about web connector...

Troubleshooting the Power Query Web connector - Power Query | Microsoft Learn

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yiruan-msft
Community Support
Community Support

Hi @Razik_BNPL ,

Please use Web.Page instead of Web.BrowserContents, and paste the below codes in your Advanced Editor. Please find the details in the attachment.

let
  Source = Web.Page(Web.Contents("https://storage.googleapis.com/play_public/supported_devices.html")),
  Navigation = Source{0}[Data]
in
  Navigation

vyiruanmsft_0-1685413631304.png

In addition, you can refer the following link to try to resolve the problem about web connector...

Troubleshooting the Power Query Web connector - Power Query | Microsoft Learn

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors