Forum Discussion
Post PartisanBypass 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 pop up.
Is there any way to bypass this?
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
4 Replies
- mahoneypat
Microsoft Employee
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
Hi Setis
Di you solve you problem?
i am trying to extract dasta from the same url as you, but I am stuck on Cookie consent tables.....
Syndicate_AdminAdministrator
Same 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.
