How to get data from html span tag

[Kapcer]

Hi, I am trying to get this https://lol.fandom.com/wiki/LEC/2022_Season/Summer_Season/Match_History into Power BI using web connection in get data. I want to get the title associated with the pictures. The pictures under Red and Blue are stored as html <a> tags and I can get them with Add table using examples option. The pictures in Bans and Picks are stored as <span> and I just can't find a way to get the related data. Do you know any way to load this data into Power BI? 

[Anonymous · Accepted solution]

Hi  @Kapcer ,

You can try using the M language in Power Query:

https://docs.microsoft.com/en-us/powerquery-m/html-table

This is the related document, you can view this content:

https://stackoverflow.com/questions/62780774/is-there-a-way-to-extract-the-title-attribute-content-f...

Web Page Display in Power BI Desktop - Microsoft Power BI Community

Solved: Re: See Records is Showing Data with HTML Tags - N... - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.