Bypass cookies consent on web scraping

[setis]

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?

[Syndicate_Admin]

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.

[phsc]

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.....

[setis]

Hi @phsc sorry, I did not. Please let me know if find a way. 

[mahoneypat · Accepted solution]

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/4...

= Web.Contents("https://myapp.example.com/api/test.php", [Headers=[Cookie="PHPSESSID=123abc"]])

Regards,

Pat