ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 效率神器,一键搞定繁琐工作
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
让更多数据处理,一键完成 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
查看: 446|回复: 2

[求助] Power BI抓取网页数据时总会有少部分数据变为空值

[复制链接]

TA的精华主题

TA的得分主题

发表于 2022-6-5 10:50 | 显示全部楼层 |阅读模式
本帖最后由 戴泽 于 2022-6-5 11:00 编辑

初学BI ,尝试抓取抖音up主的赞评等数据,我通过网页前端代码已经找到该up主所有短视频链接,一顿猛如虎操作(见下图流程),发现总会有小部分短视频返回的数据显示为空值,但是刷新预览后发现之前显示空值的刷新后能显示,但是之前能显示的刷新后可能又有变为空值的……请问大哥大佬大神们我哪里操作出错了呢?
1654394228398.jpg
1、通过一个短视频网址抓取数据↑
1654394492587.jpg
2、示例添加表增加了【标题】、【发布时间】、【点赞】、【评论】、【收藏】几个字段并并都填充了示例数据↑
1654394744627.jpg
3、高级编辑里面把短视频网址定义为p  ↑
1654395201263.jpg
4、导入之前准备好的所有需要爬取的短视频网址Excel ↑
1654395331541.jpg
5、添加列调用自定义函数↑
image.jpg
6、返回数据展开↑
大部分数据都能抓取,但是有少部分数据就是空值
刷新预览,结果还是有部分为空值,而且最下面数据报错

image.jpg

TA的精华主题

TA的得分主题

 楼主| 发表于 2022-6-5 11:02 | 显示全部楼层
本帖最后由 戴泽 于 2022-6-5 11:06 编辑

不知道是我操作不对还是咋的,上传不了附件,我拉取了部分网址直接展示吧
网址
www.douyin.com/video/7104910497652215078
www.douyin.com/video/7104560510263233806
www.douyin.com/video/7104451685749198094
www.douyin.com/video/7103848508129578247
www.douyin.com/video/7101991622770035976
www.douyin.com/video/7102253025397443848
www.douyin.com/video/7101254483241389325
www.douyin.com/video/7099763440419409182
www.douyin.com/video/7098614177673121032
www.douyin.com/video/7098271135116135711
www.douyin.com/video/7096799441478356263
www.douyin.com/video/7094448673467256102
www.douyin.com/video/7093772556179705092
www.douyin.com/video/7092721842217045259
www.douyin.com/video/7091892041851981092
www.douyin.com/video/7090817519174307105
www.douyin.com/video/7089742539179166987
www.douyin.com/video/7089381947146898692
www.douyin.com/video/7088981408949030156
www.douyin.com/video/7088145121417366823
www.douyin.com/video/7087938352913108262
www.douyin.com/video/7086408732023770375
www.douyin.com/video/7084807917945310503
www.douyin.com/video/7084169777995975943
www.douyin.com/video/7083436942838287655
www.douyin.com/video/7081949558170733828
www.douyin.com/video/7080701010930388228
www.douyin.com/video/7078967406013582625
www.douyin.com/video/7078247749510008096
www.douyin.com/video/7077131831966960933
www.douyin.com/video/7076004356574727456
www.douyin.com/video/7073773549344918821
www.douyin.com/video/7073032906163227942
www.douyin.com/video/7071915274563276035
www.douyin.com/video/7071277702862376200
www.douyin.com/video/7070402068904693031
www.douyin.com/video/7070087360108662053
www.douyin.com/video/7068204481158106401
www.douyin.com/video/7067479562115878182
www.douyin.com/video/7067108464841035011
www.douyin.com/video/7066277585906420995
www.douyin.com/video/7065619612045495555
www.douyin.com/video/7064505531603373324
www.douyin.com/video/7064020366091488524
www.douyin.com/video/7063422013704015107
www.douyin.com/video/7063018410346663201
www.douyin.com/video/7060712170119580961
www.douyin.com/video/7060054765874515239
www.douyin.com/video/7059758467883552011
www.douyin.com/video/7059606763015867686
www.douyin.com/video/7059574334435642662
www.douyin.com/video/7058522569732902148
www.douyin.com/video/7055594676614630688
www.douyin.com/video/7054193013605551364
www.douyin.com/video/7053742759630425356
www.douyin.com/video/7052999481125506316
www.douyin.com/video/7052630009256693004
www.douyin.com/video/7051894730371665155
www.douyin.com/video/7051018980860972327
www.douyin.com/video/7050800552984317216
www.douyin.com/video/7050758818497662240
www.douyin.com/video/7050420546936311047
www.douyin.com/video/7047807506571218209
www.douyin.com/video/7047487996685290764
www.douyin.com/video/7047061741565381926
www.douyin.com/video/7046715567201455371
www.douyin.com/video/7046311873976798467
www.douyin.com/video/7045576322571128096
www.douyin.com/video/7044850169384275232
www.douyin.com/video/7044855453150383371
www.douyin.com/video/7044486382823148803
www.douyin.com/video/7044384103524863271
www.douyin.com/video/7043733878162427147
www.douyin.com/video/7043354050787560737
www.douyin.com/video/7042982223930313988
www.douyin.com/video/7042615374545833228
www.douyin.com/video/7042250500665855270
www.douyin.com/video/7041876084635274500
www.douyin.com/video/7041183681200835843
www.douyin.com/video/7040831848871726375
www.douyin.com/video/7040271625077509379
www.douyin.com/video/7039271900274560264
www.douyin.com/video/7036298162449009953
www.douyin.com/video/7034439686210833694
www.douyin.com/video/7033345044056722724
www.douyin.com/video/7032988502648278286
www.douyin.com/video/7032233471330307335
www.douyin.com/video/7031475603962367262
www.douyin.com/video/7031111800649272584
www.douyin.com/video/7030736698153798948
www.douyin.com/video/7030277228772478221
www.douyin.com/video/7030002317051038984
www.douyin.com/video/7029643728797142280
www.douyin.com/video/7029255218365861150
www.douyin.com/video/7028903838048472351
www.douyin.com/video/7028786564520021278
www.douyin.com/video/7028554259641732359
www.douyin.com/video/7028167315732581639
www.douyin.com/video/7028070557530836254
www.douyin.com/video/7027762616420371743
www.douyin.com/video/7027386282380758280
www.douyin.com/video/7027028924303478046
www.douyin.com/video/7026655511256894750
www.douyin.com/video/7026318474926509343
www.douyin.com/video/7025915133901753637
www.douyin.com/video/7025586077758934309
www.douyin.com/video/7025548635270073637
www.douyin.com/video/7025160991126129957
www.douyin.com/video/7024827460546071815
www.douyin.com/video/7024446353854008606
www.douyin.com/video/7024425707170254110
www.douyin.com/video/7024057969373383944
www.douyin.com/video/7023703718327569701
www.douyin.com/video/7023680439449586951
www.douyin.com/video/7023631521605061918
www.douyin.com/video/7023593081148607758
www.douyin.com/video/7023214425607769374
www.douyin.com/video/7023208119689891086
www.douyin.com/video/7022967837731933471
www.douyin.com/video/7022570303138155806
www.douyin.com/video/7022544606118169870
www.douyin.com/video/7022453343574379790
www.douyin.com/video/7022242002708221191
www.douyin.com/video/7022163368140229918
www.douyin.com/video/7022100661265353991
www.douyin.com/video/7021832032745508110
www.douyin.com/video/7021467726581419271
www.douyin.com/video/7021094745552194846
www.douyin.com/video/7020750640896871693
www.douyin.com/video/7020701837972000036
www.douyin.com/video/7020666257456254244
www.douyin.com/video/7020378750923574567
www.douyin.com/video/7019530766996606215
www.douyin.com/video/7019916586098216205
www.douyin.com/video/7019617854458842376
www.douyin.com/video/7019282280933854494
www.douyin.com/video/7019132688766471432
www.douyin.com/video/7018490922413346062
www.douyin.com/video/7018119247238827277
www.douyin.com/video/7017760652517215501
www.douyin.com/video/7017357027324300557
www.douyin.com/video/7016995775477484831


TA的精华主题

TA的得分主题

发表于 2022-6-5 22:20 | 显示全部楼层
我好像遇到过,好像刷新时有个响应时间。
delay一下就可以了!
您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-11-16 09:36 , Processed in 0.035368 second(s), 11 queries , Gzip On, MemCache On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表