power query how to load an embedded table from a webpage?

[heidiwang1234]

Hi,

I am new to power query and was trying to extracting data from this webpage
消防产品CCCF证书查询网
The page is in Chinese, sorry for the inconvenience

However, only the first row is shown in the excel and the main body of the table can be found no where. I checked the page source code and found the following info. My question is how to edit the M function so Power query will be able to extract the main body of the table out to the excel? Thanks in advance.


<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#B9D9E8"> <tbody><tr> <td width="30%" bgcolor="#E9F2F8" class="so_rs_title">产品信息</td> <td width="20%" bgcolor="#E9F2F8" class="so_rs_title">认证编号</td> <td width="10%" bgcolor="#E9F2F8" class="so_rs_title">有效开始日期</td> <td width="10%" bgcolor="#E9F2F8" class="so_rs_title">有效截止日期</td> <td width="10%" bgcolor="#E9F2F8" class="so_rs_title">准入状态</td> </tr> <tr> <td colspan="6" bgcolor="#FFFFFF"> <tr> <td width="35%" align="left">   产品类别 ：防火阻燃材料 <br>   产品名称 ：<a href="/index.php?g=&m=Productdoc&a=index&id=260585&mid=" target="_blank" style="color: #BC2501;"> 防火膨胀密封条
</a><br>   产品型号 ：fpj-b-15;4<br> <!--   商  标 ：<br>-->   申请企业 ：成都新兴富皇高分子材料科技有限公司 
</td> <td width="15%" align="left"> 证书编号 ：<br> <a href="/index.php?g=&m=reportdoc&a=index&" target="_blank" class="orange"> </a><br> 检验报告 ：<br> <span class="orange"> </span> <br> </td> <td width="10%" align="center">2010-02-10 </td> <td width="10%" align="center"> </td> <td width="10%" align="center">  <span style="color:red;font-weight:bold">无效</span> </td> </tr> </tbody></table>

 

[Matt Allington]

I can't read the Chinese characters so I can't comment in the specifics. But I can tell you that Power Query can only extract data from a web page if it is in a suitable tabular format such as HTML, PHP etc. It won't work on JavaScript rendered tables and many other types. In my experience, you connect and see if you can find it. If not, then give up.

 

[heidiwang1234]

Thanks Matt. I decided to give up on this webpage. Will try with some other source.