Forum Discussion
setis
Post Partisan
5 years agoBypass cookies consent on web scraping
Dear experts, I'm trying to extract a table from here https://www.nordea.dk/privat/produkter/kort/valutakurser.html , but the only thing I'm able to see is data related to the cookies consent po...
- 5 years ago
I believe you can pass the cookie values in the header to avoid that like this. You would have to look at the site to get the cookie name and value for it. I copied this from a previous solved post - https://community.powerbi.com/t5/Desktop/Passing-Cookie-using-Web-Contents-in-PowerBI-Desktop/td-p/492628
= Web.Contents("https://myapp.example.com/api/test.php", [Headers=[Cookie="PHPSESSID=123abc"]])Regards,
Pat
Syndicate_Admin
Administrator
2 years agoSame problem here.
I'm unable to fetch data from https://www.synology.com/fr-fr/compatibility?search_by=category&category=hdds_no_ssd_trim
Blocked by that popup
This is getting more en more annoying for connections from Europe because of new legislations that require user consent for accepting cookies
This is going to completely break getting content from web in Power Query.