Forum Discussion
setis
Post Partisan
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 po...
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
mahoneypat
Microsoft Employee
Microsoft EmployeeI 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