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

戴泽

初学BI ，尝试抓取抖音up主的赞评等数据，我通过网页前端代码已经找到该up主所有短视频链接，一顿猛如虎操作（见下图流程），发现总会有小部分短视频返回的数据显示为空值，但是刷新预览后发现之前显示空值的刷新后能显示，但是之前能显示的刷新后可能又有变为空值的……请问大哥大佬大神们我哪里操作出错了呢？

1、通过一个短视频网址抓取数据↑

2、示例添加表增加了【标题】、【发布时间】、【点赞】、【评论】、【收藏】几个字段并并都填充了示例数据↑

3、高级编辑里面把短视频网址定义为p  ↑

4、导入之前准备好的所有需要爬取的短视频网址Excel ↑

5、添加列调用自定义函数↑

6、返回数据展开↑
大部分数据都能抓取，但是有少部分数据就是空值
刷新预览，结果还是有部分为空值，而且最下面数据报错

戴泽

不知道是我操作不对还是咋的，上传不了附件，我拉取了部分网址直接展示吧

网址

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

luzwales

我好像遇到过，好像刷新时有个响应时间。
delay一下就可以了！