Forum Discussion
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 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?
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:
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.
1 Reply
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:
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.