Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

Web scraping error

Hello guys,

 

How to deal with this error:

 

image.png

Function:

 

= (data as text) as table=>

let
Source = Web.BrowserContents("https://krisha.kz/prodazha/kvartiry/almaty/?das[flat.priv_dorm]=2&das[house.floor_num][from]=4&das[house.year][from]=1970&das[live.rooms][]=1&das[live.rooms][]=2&das[live.square][to]=70&das[price][from]=5000000&das[price][to]=10000000&page="&data),

#"Extracted Table From Html"= Html.Table(Source, {{"Column1", ".a-card__title"}, {
"Link", 
"a[href^=""/a/show/""]", 
each [Attributes][href]}}, [RowSelector=".a-card__title"])
in
#"Extracted Table From Html"

 

 

1 REPLY 1
Anonymous
Not applicable

Hi @Anonymous ,

I test your function with a single parameter and it works well.
I guess you are invoking this function in another table who contains large amount of records and tries to loop through each row based on its field value as a parameter from that table, right?

If this is a case, I'd like to suggest modify your function to get these pages in one request instead send invoke function multiple times. (It will spend a lot of time to send the request and receive each record)
Regards,

Xiaoxin Sheng

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors