Hi, @alfst28 ,
Power BI’s connector can’t interact with cookie banners or popups like a real browser can. That’s why you just see the HTML or a “cookies required” message in your table preview, even though the Web View tab shows the right data (since that uses your browser session). Here’s what usually works for sites like this:
1. Pass Cookies Manually: If you know the exact cookie set after you accept the consent, you can sometimes “trick” the site with Power Query like this: Source = Web.Contents("https://yourwebsite.com", [Headers=[Cookie="your_cookie_name=your_cookie_value"]])
2. Download the Page After Accepting Cookies: Just save the web page after you’ve accepted all cookies, then load that file into Power BI. It’s manual but can be enough for quick reports.
3. Use a Script or Browser Automation: If you need to do this regularly, a tool like Python’s Selenium can open the page, click “accept,” grab the table, and save it as CSV for Power BI to import. Not as scary as it sounds—there are plenty of tutorials if you Google “Selenium web scraping.”
4. Look for APIs or Data Downloads: Always check if the table is available as a direct download (CSV, JSON, or Excel), or if there’s an API endpoint in the background. Check the Network tab in browser dev tools while the page loads.
Long story short: Power BI can’t click popups or accept cookies on your behalf. But with these workarounds, you can still get the data in, just takes a bit of setup.
If you get stuck grabbing the right cookie value, or want a sample Python script, let me know (or DM me the site and I’ll take a quick look).
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
