Data extraction using power query doesnt extract email address. instead of email address [email protected] is shown
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
I have attached files as reference.
- Screenshot of original web data
- Screenshot of Extracted Data
- Excel Extract
4
Thanks
Usman
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 Mynda
Thanks for your swift response.
I earlier posted this query on YouTube. You advised to post on forum as you have solution to scrap emails as well.
Appreciate if you can advise as data is open and Public but only problem it's not scrapping using power query.
Thanks
Usman
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