获取在查询刷新期间传输的数据量
有没有办法跟踪查询刷新期间传输的数据量？
大小在“查询”窗格中显示非常简短（取决于等待）：
我能想到的唯一解决方案是将纯输出保存到CSV并测量文件。
是否有更直接，更麻烦的方式？
背后的主要原因是我想看到：
1：如果大小可能会给连接缓慢的用户引起问题
2：我的优化尝试的效果，
请注意，这将是理想情况下是源，但是我的主要重点是SharePoint列表＆amp;文件。
Is there a way to track the amount of data transferred during query refresh?
The size is shown in the 'Queries' pane very briefly (depending on the wait):
The only solution I can think of is saving the pure output to CSV and measuring the filesize.
Is there a more direct, less cumbersome way?
The main reason behind this is that I want to see:
1: If the size could cause issues to users with slow connections
2: The effect of my optimisation attempts
Please note that this would ideally be source-agnostic, however my primary focus are SharePoint lists & files.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我认为您无法执行此操作，但是您可以通过连接SharePoint文件夹，然后钻入属性记录并获取大小记录来检查文件
大小
https://learn.microsoft.com/en-en-poper-us/power-us-poper-us-us-us-us-us-us-us-us-us-us-us-us-us-us-us-us-us-us-us-us-us-us-us-us-us-poper-us-us-us-查询/连接器/SharePointFolder
或
https://www.myononlinlinetaininghub.com/ get-data-from-onedrive-or-sharePoint-with-power-Query
示例示例示例的示例版本，但不是SharePoint
I don't think you can do that, but you could check the file size by connecting the the sharepoint folder, then drilling into the Attributes record and grabbing the Size record
See
https://learn.microsoft.com/en-us/power-query/connectors/sharepointfolder
or
https://www.myonlinetraininghub.com/get-data-from-onedrive-or-sharepoint-with-power-query
sample for desktop version, but not sharepoint