Forum Discussion

Frequent Visitor

3 years ago

Solved

How to get data from html span tag

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 pic...

Anonymous
3 years ago
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-from-a-span-using-power

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.

Anonymous

Not applicable

3 years ago

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-from-a-span-using-power

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.