
Active Member

May 22, 2021

Data extraction using power query doesnt extract email address. instead of email address is shown

Active Member

May 22, 2021

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


July 16, 2010

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
1 Guest(s)
