Data extraction using power query doesnt extract email address|Power Query|Excel Forum|My Online Training Hub

Hi Usman,

No file attached so it's difficult to understand the issue. I suspect the source data you're using is preventing exposure of the email address, as there's nothing built into Power Query that prevents email addresses from loading.

Mynda

Hi Usman,

If you look at the source code of that web page (right-click the web page > view source) you can see it is protecting the email from being scraped by bots, which also prevents Power Query from downloading it. 

Mynda

Hi Usman,

I did not "advise to post on our forum as I have solution to scrap emails as well." I said if you post your question on our forum I will help you, which is what I've done. I've looked at the web page and can see that this is not a Power Query issue, it's being prevented by the web page.

The data might be visible to the public on the face of the web page, but isn't open to scraping. Power Query looks at the source code of the page and if you do that as I suggested, you'll see that the email address is not visible to Power Query. This is intentional by the web developer. Power Query can't do anything about this if that's what they choose to do. To be clear, I don't have a workaround if the web developer prevents their web pages from being scraped.

Sorry I don't have a solution, but I hope I've explained what the issue is.

Mynda