Get a part of text from website

[Anonymous]

Hello,

I have some specific web links where I can see howmany of my products are live at the moment on these specific marketplaces.

I would like to select this specific part of the webpage with the Get Data from Web option. But when I do this, it get's a little messy with all HTML codes from that page.

However, the result I need is somewhere in all this text, but the question is, how can I select this small part I need from all the text I have?

Example of just a small part attached.

[Syndicate_Admin]

Hi @Thomdh ,

When you have the get from web navigator open, you should be able to hit the 'Add Table Using Examples' button here:

Double-click in the first row of the example table and start typing the value from the webpage that you want to get. Power BI should then give you options of similar entries in a dropdown box, and should load the CSS Selector for that value.

Once you hit OK, it should load you a table with the correct segment of the HTML coded into the M:

Pete

[BA_Pete · Accepted solution]

Hi @Anonymous ,

When you have the get from web navigator open, you should be able to hit the 'Add Table Using Examples' button here:

Double-click in the first row of the example table and start typing the value from the webpage that you want to get. Power BI should then give you options of similar entries in a dropdown box, and should load the CSS Selector for that value.

Once you hit OK, it should load you a table with the correct segment of the HTML coded into the M:

Pete

[Anonymous]

Hi Pete,

Thanks a lot!

How ever, do you also know how I can get arround the cookie acceptance part?

I checked your example, and indeed it works. But it looks like I have to accept cookies first in order to get to the correct page:

[BA_Pete]

Hi @Anonymous ,

Try this thread:

https://community.powerbi.com/t5/Power-Query/Bypass-cookies-consent-on-web-scraping/td-p/1460943 

Pete