Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there
Many websites have popups asking what cookies to allow, how do I get past these popups and load the content directly?
Best Regardes
Søren
Hi @Anonymous ,
Based on my test, the data scraped by the webpage does not seem to be affected by the cookie.
let
Source = Web.BrowserContents("https://www.betriheim.fo/solulisti/"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".section-inner BR + A"}, {"Column2", ".suggestedPrice"}, {"Column3", ".latestBid"}, {"Column4", ".icon-buildingSize + *"}, {"Column5", ".icon-buildingBedrooms + *"}, {"Column6", ".icon-plotSize + *"}, {"Column7", ".icon-buildingFloors + *"}, {"Column8", ".icon-buildingYearBuilt + *"}, {"Column9", ".suggestedPrice *"}}, [RowSelector=".section-inner BR + A"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}})
in
#"Changed Type"
I used to get data from the web, and the credentials were obtained anonymously.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Stephen
Thanks for your effort.
Your proposed script does not provide usable data, I get a table with the email adress heim@betri.fo in column1 as the only data.
Am I doing something wrong?
Best regards
Søren
Hi Stephen
Thanks for your effort.
Your proposed script does not provide usable data, I get a table with the email adress heim@betri.fo in column1 as the only data.
Am I doing something wrong?
Best regards
Søren
Hi @Anonymous ,
My fault, sorry. Because copying the code directly to the advanced editor seems to make an error. Please try to follow the steps in my gif to connect to the web.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi again Stephen
Hi again Stephen
I tried on another computer and got what you show in your GIF. But data only appears as examples, when I load I get again only one row with an email address just like when I copy the query directly in the advanced editor.
Strange?
It looks like something is happening from preview to loading.
Best Regards
Søren
Hi Stephen
I dont get the same screens as you?
I get:
which is the content of the cookie.
Best Regards
Søren
Hi @Anonymous ,
Please kindly refer to the similar post:
Passing Cookie using Web.Contents in PowerBI Desktop
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Stephen
Thanks for the replay, it unfortuntely does not solv my problem. This is the website I'm trying to scrape: https://www.betriheim.fo/solulisti/