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

Get data from the Web - error 302

Hi,

 

I am using this URL that works fine in the browser.  When I try to connect in Power Query (Get data) I get a 302 error.  Is there a workaround to this error?  Can I find the original URL instead of the redirected URL? 

 

https://sms-sgs.ic.gc.ca/licenseSearch/searchSpectrumLicense?execution=e1s3&licenceNumber=010884140-...

 

Thanks

Serge

3 REPLIES 3
SchBI67
New Member

Hi,

 

I plan to do some web scraping once there.

 

Thanks

lbendlin
Super User
Super User

That's just a landing page, and it seems to fall over a lot

lbendlin_0-1686352595272.png

 

What are you planning to do next once there?

 

Handling status codes with Web.Contents for Power Query connectors - Power Query | Microsoft Learn

I plan on doing some web scraping. Thanks

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
Top Kudoed Authors